Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How to add a Combobox dynamically based on contents of some other cell?

Hi,

I am new to VBA, but know excel. I have the following query :

1. I need to check the 1st column (A) of each row, and if it is not
empty, add a combobox to column B of that row.

Trivial .. I hope i will be able to do it, but seggestions welcome :
2. I need to be populate the combobox with data from some other sheets
in the same workbook
3. I need to be able to go to a specific web page if any combobox
entry is clicked. For eg : if entry 1234 is clicked, i should go to
http://www.example.com/1234

Any pointers , especially to (1) above, are appreciated.

Any good startup resources on the net (free, please) are also welcome
:)

Thanks
Abhinav
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default How to add a Combobox dynamically based on contents of some othercell?

No suggestions .. .? :)

Regards
Abhinav
(p.s. sorry to post from multiple IDs, but my news server wasnt working
earlier)

Abhinav wrote:
Hi,

I am new to VBA, but know excel. I have the following query :

1. I need to check the 1st column (A) of each row, and if it is not
empty, add a combobox to column B of that row.

Trivial .. I hope i will be able to do it, but seggestions welcome :
2. I need to be populate the combobox with data from some other sheets
in the same workbook
3. I need to be able to go to a specific web page if any combobox
entry is clicked. For eg : if entry 1234 is clicked, i should go to
http://www.example.com/1234

Any pointers , especially to (1) above, are appreciated.

Any good startup resources on the net (free, please) are also welcome
:)

Thanks
Abhinav


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamically reference a cell based on cell content Fuad Excel Discussion (Misc queries) 2 May 13th 10 08:56 PM
Dynamically setting CELL COLORS based on TWO OTHER cell values Tom Excel Discussion (Misc queries) 3 February 22nd 09 07:34 PM
creating a combobox dynamically on an excel sheet gupt New Users to Excel 8 June 7th 05 04:07 AM
Dynamically adding data to a Combobox? samanathon Excel Programming 4 April 5th 04 11:26 AM
Changing the contents of a cell... dynamically? Friendly Indián Excel Programming 14 February 4th 04 01:13 PM


All times are GMT +1. The time now is 04:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"