Thread: OptionButton
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nrage21[_69_] nrage21[_69_] is offline
external usenet poster
 
Posts: 1
Default OptionButton


I have 3 optionbuttons on a form:

completed (Optionbutton1)

Rescheduled (Optionbutton2)

Cancelled (Optionbutton3)

I would like to display the status word on a cell I have designate
(i.e. when Optionbutton1 is selected and I press the ok button the wor
"Completed" appears on my designated cell)

How to make this work????

If OptionButton101.Value = True Then
the word "Completed" appears on my designated cell

I'm sure this is easy stuff... please help!

- Larry -
VBA Amateu

--
nrage2
-----------------------------------------------------------------------
nrage21's Profile: http://www.excelforum.com/member.php...nfo&userid=480
View this thread: http://www.excelforum.com/showthread.php?threadid=26443