Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have a dialog box in which there are a number of frames(fraMWidth) containing option buttons. I'm trying to use Select Case statements to define values dependant on which option button is chosen. I'm struggling with the code and would appreciate any assistance. A snippet of code so far is: Dim MWidth as integer Select Case fraMWidth.Control.Value Case optW20 = True MWidth = 20 Case optW16 = True MWidth = 16 Case optW12 = True MWidth = 12 Case optW10 = True MWidth = 10 Case optW8 = True MWidth = 8 Case optWOther = True MWidth = txtWOther.Value End Select TIA -- Al@n |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF Statements to Select Case??? | Excel Discussion (Misc queries) | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
CASE STATEMENTS | Excel Programming | |||
Using Select Case Statements | Excel Programming |