Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Sheet Names into Combo Box
I have four worksheets. The first sheet ("Inputs") has a combo bo
which loads the sheets names of all the sheets in the workbook. Th remaining three sheets are called "Case 1", "Case 2", and "Case 3". The problem is that the code below loads the sheet names properly but: 1) I do not want the input sheet included in the list 2) after the click event, the chosen item from the list does not sta loaded in the combo box What is wrong with this? Thanks Private Sub ComboBox1_Click() Dim Sh As Worksheet With ComboBox1 .Clear For Each Sh In ActiveWorkbook.Sheets .AddItem Sh.Name Next End With End Su -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Referencing - autofilling sheet names | Excel Worksheet Functions | |||
Cell names = sheet names | Excel Worksheet Functions | |||
Loading a Combo Box with the months of the year | Excel Discussion (Misc queries) | |||
Excel sheet not loading | Excel Discussion (Misc queries) | |||
VBA for opening file/populating combo box with sheet names | Excel Programming |