ascopeland
New Member
- Joined
- Feb 9, 2009
- Messages
- 1
In my excell worksheet i am using a combo box, and the list in the combo box has been defined in the following code:
Private Sub ComboBox_AnalysisMode_Change()
ComboBox_AnalysisMode.List = Array("Nominal", "Best Case", "Worst Case")
End Sub
When i start up excel the default item in the combo box is whatever it was set to when i previously closed excel. when i click on the box though the other items in the list do not show up.
to get the other items to show up i have to open the code and run it. i am sure i just need to initialize the box somehow when the worksheet opens up, but how do i do that?
Private Sub ComboBox_AnalysisMode_Change()
ComboBox_AnalysisMode.List = Array("Nominal", "Best Case", "Worst Case")
End Sub
When i start up excel the default item in the combo box is whatever it was set to when i previously closed excel. when i click on the box though the other items in the list do not show up.
to get the other items to show up i have to open the code and run it. i am sure i just need to initialize the box somehow when the worksheet opens up, but how do i do that?
