View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Craig[_21_] Craig[_21_] is offline
external usenet poster
 
Posts: 39
Default Optionbutton help

HI there,

I have a Userform with some optionbuttons on it. Named optionbutton1 thru 4.
Each button is linked to a worksheet cell. I want, that when I click an
optionbutton it becomes TRUE and the other
optionbuttons become FALSE.
I have these buttons grouped.
What happens is that if optionbutton4 is TRUE and I click optionbutton1...
optionbutton4 becomes FALSE but optionbutton1 doesn't become TRUE unless I
click it again.

How do I make this happen with one click??

Thanks in Advance...Again!
Craig