Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello out there!
I want to use the same items several times in different comboboxes, i.e. a currency selection (EUR, USD, SEK, DKK......). There are 7 instances where the user selects the currency to use (and it can be different currency at every selection). Instead of reading the list from a sheet or writing the same ComboboX.AddItem= "EUR" and so on for every new combobox, I wanted to use an array and a for...next loop that can be used for every combobox creation. But, arrays are not allowed in for...next statements. Can it be done in another neat way? Best regards Mats |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Grouping Items by Arrays | Excel Discussion (Misc queries) | |||
Put items in combobox using VBA and toolbox | Excel Programming | |||
how to add items to combobox | Excel Programming | |||
ComboBox Items | Excel Programming | |||
ComboBox items | Excel Programming |