Combo box property

cwng3

New Member
Joined
Nov 7, 2005
Messages
31
Hi,

I am trying to create a set of combo box (over 100) in run time. How can I do it in vba and set the linkedcell and ListFillRange of them ?

Thanks
TT
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
I think I'm after the same thing as the original author...

I'm constructing a spreadsheet for people to fill in.
I want them to choose from 3 headings: Banks,Commercial and Insurance, then in each heading, there are 6 different titles.
Is it possible for me to allow the user to select the heading they want, then the correct 6 titles come up under it? Can I use Data Validation for this? I've just learnt the basics. Or would I do the long-winded way and autofilter each titles instead (under the correct heading)?

Thanks
 
Upvote 0
Phat_girl said:
I think I'm after the same thing as the original author...

I'm constructing a spreadsheet for people to fill in.
I want them to choose from 3 headings: Banks,Commercial and Insurance, then in each heading, there are 6 different titles.
Is it possible for me to allow the user to select the heading they want, then the correct 6 titles come up under it? Can I use Data Validation for this? I've just learnt the basics. Or would I do the long-winded way and autofilter each titles instead (under the correct heading)?

Thanks

Welcome to the Board.

Look here:

http://www.mrexcel.com/board2/viewtopic.php?t=53213
 
Upvote 0

Forum statistics

Threads
1,223,429
Messages
6,172,046
Members
452,444
Latest member
ShaImran193

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top