tony2501
05-02-2011, 01:54 PM
Thanks in advance for any help.
In this workbook I have several(about 25) worksheets, each of which has 3 combo boxes on them, which I want to use to navigate between the different worksheets. So the items in each combobox will be the same on each sheet.
What I want to do is run some module based code that will propulate the active sheets combo box, the comboboxes are named the same on each sheet.
The code I was thinking about would be something like:
SheetName.cboOne.Additem "Item1"
Where SheetName woud change depending upon the active sheet.
The problem I have is assigning the sheet name to some sort of variable which would achieve this.:banghead:
In this workbook I have several(about 25) worksheets, each of which has 3 combo boxes on them, which I want to use to navigate between the different worksheets. So the items in each combobox will be the same on each sheet.
What I want to do is run some module based code that will propulate the active sheets combo box, the comboboxes are named the same on each sheet.
The code I was thinking about would be something like:
SheetName.cboOne.Additem "Item1"
Where SheetName woud change depending upon the active sheet.
The problem I have is assigning the sheet name to some sort of variable which would achieve this.:banghead: