Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have a frame containing three optionbuttons. I have set the groupname in the properties inspector manaually to "TaxGroup". How do i reference this ie get the value or a value of it. Could I use the select case statement to then action on which optionbutton is true. Select Case Controls("TaxGroup").Value Case Is = 1 Case "OptionButton1": txtTax.Value = "Includes" Case "OptionButton2": txtTax.Value = "Excludes" Case "OptionButton3": txtTax.Value = "Non Taxable" End Select garry *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ISFORMULA(Cell Referance) | Excel Worksheet Functions | |||
Help with a formula. Lookup? referance? | Excel Worksheet Functions | |||
Circular Referance | Excel Discussion (Misc queries) | |||
GroupName | Excel Programming | |||
Cross Referance | Excel Programming |