Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Populating multiple combo boxes
Geoff, It works! But.....because the combo boxes are now in frames I'm finding it difficult to set the tab properties. There are a lot of controls on the form and everytime I try to change them VB changes them to whatever it wants. Any ideas?- mattboo
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Populating multiple combo boxes
Geoff, Nice one! I'l give it a go and let you know how I get on. Thanks for your help! Matt- mattboo
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Populating multiple combo boxes
Geoff, Cheers! That was my first thought too. Unfortunately I have another 10 different comboboxes on the same form which need different items adding. I've tried creating a collection with intentions of looping over that but adding an item adds the current value (text) of the control instead of...- mattboo
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Populating multiple combo boxes
Hello All! Suppose I have a form which, among other controls, has ten different combo boxes. I wish to populate each of these combo boxes with the same 15 items. Is there anyway to do this without having to write 150 lines of code? A loop of some sort would be preferable. Can anyone help...- mattboo
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
