| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Then statement in a userform sub
Hi all:
The following sub is for the "OK" button on the userform. Private Sub CommandButton1_Click() If OptionALL Then Cells(1, 2).Value = "ALL" Call Analyze If OptionSelect Then Cells(1, 2).Value = TextBox1.Text Call Analyze2 JOIST.Hide End Sub The problem is when the first "IF" statement is not true it does not skip "Call Analyze" which is a sub in the standard module. how can i make it,when the first "if" statement is not true, to go to the second "if" statement? Thanks for any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Statement to give focus to a specific control on a UserForm? | Excel Programming | |||
| Access from add_in userform to main template userform.... | Excel Programming | |||
| Linking userform to userform in Excel 2003 | Excel Programming | |||
Threaded Mode
