View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Newbeetle Newbeetle is offline
external usenet poster
 
Posts: 98
Default Set all option buttons on worksheet to off

Hi I use the following below to set all checkboxes on sheet 1 to off, can the
same be done for option buttons on sheet 1. The option buttons used are from
the forms toolbar.


Private Sub clear_Click()
Worksheets("sheet1").CheckBoxes.Value = xlOff
End Sub


Have tried a copy of ideas but I haven't got there yet.
--
This post was created using recycled electrons!