Good morning,
I recieve an excel file weekly that has around 100 dropboxes in it. Each dropbox containing about 300 items that are not in numerical or alphabetical order. I have found that an Activex Combo box allows me to see 35 rows of dropbox to make it an easier process to select from each one. I would like to set up a VBA that can create 100 Activex Combo boxes linked to the required cells. EG: i would like a Activex combobox in cell H2 Timesheet1 with linkedcell H3 and listfillrange of 'Labour Code'!A3:A290 and 35 listrows. Then a Activex combobox in cell i2 Timesheet1 with linkedcell i3 with listfillrange of 'Labour Code'!A3:A290 and 35 listrows, then same for J2, K2, L2 etc etc.
I have been able to create the combobox but have had no luck setting the properties by VBA
Cheers Mark
I recieve an excel file weekly that has around 100 dropboxes in it. Each dropbox containing about 300 items that are not in numerical or alphabetical order. I have found that an Activex Combo box allows me to see 35 rows of dropbox to make it an easier process to select from each one. I would like to set up a VBA that can create 100 Activex Combo boxes linked to the required cells. EG: i would like a Activex combobox in cell H2 Timesheet1 with linkedcell H3 and listfillrange of 'Labour Code'!A3:A290 and 35 listrows. Then a Activex combobox in cell i2 Timesheet1 with linkedcell i3 with listfillrange of 'Labour Code'!A3:A290 and 35 listrows, then same for J2, K2, L2 etc etc.
I have been able to create the combobox but have had no luck setting the properties by VBA
Cheers Mark