Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OptionButton
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Better Way to Use OptionButton | Excel Programming | |||
Better Way to Use OptionButton | Excel Programming | |||
which optionbutton is on | Excel Programming | |||
OptionButton problem | Excel Programming | |||
optionbutton in userform | Excel Programming |