View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jm Jm is offline
external usenet poster
 
Posts: 2
Default 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