| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Button with VB code, not working
Why dosn't this work? Thanks
Sheets("INPUT_A").Select If OptionButton2.Value = True Then Sheets("AR").Select Rows("17:20,35:38,53:56,78:81,102:105,140:147,160: 167,181:187").Select Selection.Delete Shift:=xlUp Range("A1").Select ElseIf OptionButton3.Value = True Then Sheets("AR").Select Range("7:8,25:26,43:44,68:69,92:93,136:137,156:157 ,176:177").Select Selection.Delete Shift:=xlUp Range("A1").Select ElseIf OptionButton4.Value = True Then Sheets("AR").Select Range( _ "7:8,17:20,25:26,35:38,43:44,53:56,68:69,78:81,92: 93,102:105,136:137,140:147,160:163,164:167,176:177 ,180:187,156:157" _ ).Select Selection.Delete Shift:=xlUp Range("A1").Select End If Sheets("AR").Select Range("A1").Select or this: If OptionButton2 Then Call AR_GTD ElseIf OptionButton3 Then Call AR_Both ElseIf OptionButton4 Then Call AR_ECO End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option Button code not working | Excel Discussion (Misc queries) | |||
| How do I select an option button using code | Excel Programming | |||
| How to assign same code inside Option button code space ?? | Excel Programming | |||
| Code to tab from option button click | Excel Programming | |||
| Old button code not working in Excel2002 | Excel Programming | |||
Threaded Mode
