Create Activex Combo Box and configure list rows, linked cell and listfillrange using vba using VBA

MarkMacka

New Member
Joined
Jan 3, 2017
Messages
9
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
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Akuini

Well-known Member
Joined
Feb 1, 2016
Messages
2,963
Office Version
  1. 365
Platform
  1. Windows
Do you really need 100 combobox?
Here's an example of one combobox applied to multiple cells.

Let me know if you're interested in this method.
 

MarkMacka

New Member
Joined
Jan 3, 2017
Messages
9
Do you really need 100 combobox?
Here's an example of one combobox applied to multiple cells.

Let me know if you're interested in this method.
Sorry my work firewall wont let me open the link. Will this method allow me to use the one combobox to select for each of the 100 columns?
 

Akuini

Well-known Member
Joined
Feb 1, 2016
Messages
2,963
Office Version
  1. 365
Platform
  1. Windows
Will this method allow me to use the one combobox to select for each of the 100 columns?
Yes, with some modification.
But it's hard to explain without you having the sample file. Can you download it from your home computer?
 

MarkMacka

New Member
Joined
Jan 3, 2017
Messages
9
Yes, with some modification.
But it's hard to explain without you having the sample file. Can you download it from your home computer?
Im curently in a camp in Papua New Guinea and using the same work internet there. Is there a way to do a single combobox and set the linked cell etc by VBA
 

Watch MrExcel Video

Forum statistics

Threads
1,130,048
Messages
5,639,769
Members
417,111
Latest member
buyukbang

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top