View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Control Box Option Buttons

Something like

With ActiveSheet
.OptionButton1.Value = False
.OptionButton2.Value = False
.OptionButton3.Value = False
End With

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"jlarkin " wrote in message
...
Hey..

I need some help here . . . It's probably something very simple but I
dont have the know-how.

How do you clear Option Boxes (the control box type) I know how to
group them by group name -- but once selections have been made, you
cannot RESET or CLEAR the boxes. I really want to make a Button to run
a Macro that clears a form.

Any help would be GREATLY appreciated.


---
Message posted from http://www.ExcelForum.com/