View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt[_33_] Matt[_33_] is offline
external usenet poster
 
Posts: 78
Default Unselect OptionButton. How to?

Folks,

I have a macro with a data input screen.

Amongst others there are 5 optionbuttons. The macor must not continue
without one checked.

I do that by each subroutine of each option button writes the value 1
in a cell.

If there is no value 1 in that cell the macro will clear all selections
restart.

The problem is that now it cleared the 1 and it thinks no button is
selected, but really the button is STILL selected.

Is there a way to uncheck these buttons from inside the macro? OR at
least reset them all to default, like when the macro starts the first
time?

Thanks!
Matt