Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A beginners Elseif question
I have a user form I created and it has a few option buttons on it to specify
what type of suspension the customer wants. I have it set up so there are two options for spring and two main options for air. The problem I am having is if you select spring first and then decide you want air, the information you enter form there on will effect spring and not air. I put in an Elseif statement on one of the spring options but I am not sure if I need to put one on the other also or if I simply did not write it correctly. Please take a look at what I did and guide me in the right direction Private Sub OptionSpring_Click() Range("B27").Formula = "=L175" Range("J199").Value = "SPRING" Range("J203").Value = "NO LIFT" End Sub Private Sub OptionSprinL_Click() If OptionSpring = False Then ElseIf OptionSprinL = False Then Range("B27").Value = 0 End If Range("B27").Formula = "=L175-K195" Range("J199").Value = "SPRING" Range("J203").Value = "LIFT" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Beginners Question | Excel Discussion (Misc queries) | |||
Beginners Question | Excel Programming | |||
Beginners Question | Excel Discussion (Misc queries) | |||
Beginners Question setting up spreadsheet | New Users to Excel | |||
Beginners question: VAT Column | Excel Worksheet Functions |