Fill Combo boxes on each sheet

**randell.graybill** · 06-10-2009, 12:50 AM

How do I change the below code to fill all combo boxes all on sheets. All the names of the controls should be the same on each sheet since each sheet was created from a copy of the original.

Please Login or Register  to view this content.

**royUK** · 06-10-2009, 04:11 AM

see if this works

Please Login or Register  to view this content.

**randell.graybill** · 06-10-2009, 08:36 PM

I double checked that I had the right name for the combo box and i do but I get the following error

Compile error:

Method or data member not found.

What could be causing this?

**randell.graybill** · 06-10-2009, 08:41 PM

Also I tried to use the for each ws code for something slightly different but it just kept looping on the current sheet.

Please Login or Register  to view this content.

I have a spreadsheet with all of the above macros.

**royUK** · 06-11-2009, 03:59 AM

I have tidied up your code, You have it as an open event, but in a Standard Module. It must be in the workbook module

Please Login or Register  to view this content.

Copy the code
Select the workbook in which you want to store the code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
Right-click on the ThisWorkbook object, and choose View Code
Where the cursor is flashing, choose Edit | Paste

Note: delete the original code from your workbook