Combo box property

[cwng3]

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

 

[Andrew Poulsom]

Welcome to the Board.

It would be a lot easier with Data Validation.

 

[Phat_girl]

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

 

[Andrew Poulsom]

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

 

[Phat_girl]

Thanks Andrew. I'll try this. Much appreciated!

 

[cwng3]

Thanks. I think I will chnage to use validation instead of combo.