VBA Procedural Question

[Mhat]

Hi All,

I am creating a userform with combo boxes that will contain names. The aircraft that the user selects will determine how many combo boxes are needed on the form (between 9 to 20). What is the best way to go about this? Should I create a form with 20 comboboxes and then hide the boxes and resize the form depending on the number of boxes needed or is there a better way?

Regards,

Mike

 

[KMKfan]

The only way I can think of is possibly create multiple userforms. The first with only the aircraft combo, and the appropriate userform is called based the users selection. This could turn out to be way more tedious than what you propose, though. Maybe just use an event handler based on the aircraft selected in Combo1 to adjust the properties (I use .Text, .Locked, .TabStop, & .BackStyle). You may be able to set up ranges in your workbook to cut down on the amount of code you'd actually have to write (ie Case 1 = fill Combo# with a specified range and Case 2 = set properties to disable unneeded Combos).

Warning: I'm a little new to VB, so I'd have to endure trial & error with it some as far as coming up with specific code and range setup.

 

[Mhat]

Thanks for your input, I wasn't sure if there was an established procedure for this kind of thing, I don't want to reinvent the wheel.