Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Option Button Property Value with VBA
Hi,
I need to mirror the Value of a Option Button (List2) when Option Button (List1) is clicked on. Note: List1 and List2 are in different Option Button Groups. The code below give me an "Object Required" error. What do I need to change? Private Sub List1OB_Click() With Object.List2OB .Value = True End With End Sub Thanks, Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Option Button Property Value with VBA
Use
With Me.List2OB .Value = True End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jm" wrote in message ... Hi, I need to mirror the Value of a Option Button (List2) when Option Button (List1) is clicked on. Note: List1 and List2 are in different Option Button Groups. The code below give me an "Object Required" error. What do I need to change? Private Sub List1OB_Click() With Object.List2OB .Value = True End With End Sub Thanks, Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007: Property Sheet button disabled | Excel Discussion (Misc queries) | |||
Change insidewidth property | Charts and Charting in Excel | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Why does Option Button not hold transparent property? | Excel Discussion (Misc queries) | |||
Worksheet / Workbook Change Property | Excel Programming |