I would assume this is on the change event.

If(Optionbutton1=True)then
worksheets("sheetname").range("A2").value2="comple ted"
end if

-----Original Message-----

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
designated
(i.e. when Optionbutton1 is selected and I press the ok
button the word
"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 Amateur


--
nrage21
---------------------------------------------------------
---------------
nrage21's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=4808
View this thread:
http://www.excelforum.com/showthread...hreadid=264438

.