| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
passing a comboxbox result into sheets.select
I have a form that has a combo box in it. The combo box allows the user to
select a chapter. The chapter happens to be worksheet in a workbook. How do i pass from the combo box into the macro. This is what I want: With ComboBox8 .AddItem "Chapter 1" .AddItem "Chapter 2" .AddItem "Chapter 3" End With Chapter = ComboBox8.Value Sheets(Chapter).Select *** if I write Sheets("Chapter 1") it works great...but just putting it Chapter fails |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ComboxBox with Dynamically Defined Source, and LinkedCell error | Excel Discussion (Misc queries) | |||
| passing values to other sheets | New Users to Excel | |||
| Comboxbox in Commandbar | Excel Programming | |||
| Looping through Sheets and passing values to an Array | Excel Programming | |||
| Passing SQL Query Result Into A Variable | Excel Programming | |||
Threaded Mode
