LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 88
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Beginners Question GordyB Excel Discussion (Misc queries) 3 February 1st 10 10:33 PM
Beginners Question kMan Excel Programming 2 February 16th 07 02:26 AM
Beginners Question Black_op51 Excel Discussion (Misc queries) 6 November 8th 06 11:46 PM
Beginners Question setting up spreadsheet PappyJoe New Users to Excel 4 July 31st 06 04:33 AM
Beginners question: VAT Column Dave Wallis Excel Worksheet Functions 2 December 18th 04 06:04 PM


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"