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