Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Below is is my code. Question is, how do I properly write my If-then
statement to check that both combobox1 AND combobox2 have a value selected before the "Ok" button pops up? whoa as I am typing this question I realize my second Private Sub is specifically for ComboBox1....perhaps my problem?! but still way to green (ie learning as I go) to know what to try next. TIA!!!!! Private Sub UserForm_Activate() ComboBox1.AddItem "0 %" ComboBox1.AddItem "25 %" ComboBox1.AddItem "50 %" ComboBox1.AddItem "95 %" ComboBox1.AddItem "100 %" ComboBox2.AddItem "No" ComboBox2.AddItem "Yes" End Sub Private Sub ComboBox1_Change() If ComboBox1.Value < "" Then CommandButton1.Visible = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ComboBox_Change Event to Populate another Combox | Excel Programming | |||
Weird Error with ComboBox_Change() | Excel Programming | |||
Combobox_change does not repond? | Excel Programming | |||
Combobox_change event problem | Excel Programming | |||
ComboBox_Change sub runs unexpectedly | Excel Programming |