Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes on forms
Hello I have a user form With a couple of option buttons and check boxe and command button Is it poss to make the option buttons unload then selfs and fade out (Stop working) if the check box is seleted eg option 1= wood option 2= metal if checkbox is ticked the 2 above unload (both become false and not able to selet them unitl the checkbox is unticked ) hope makes sense Thanks -- Rmagic ------------------------------------------------------------------------ Rmagic's Profile: http://www.excelforum.com/member.php...o&userid=28595 View this thread: http://www.excelforum.com/showthread...hreadid=484511 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes on forms
Hello Rmagic, Code ------------------- If CheckBox1.Value = True Then OptionButton1.Value = False OptionButton2.Value = False OptionButton1.Enabled = False OptionButton2.Enabled = False Else OptionButton1.Enabled = True OptionButton2.Enabled = True End If ------------------- Sincerely, Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=48451 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes on forms
Hi Rmagic,
Try: Private Sub CheckBox1_Click() Me.OptionButton1.Visible = Not Me.CheckBox1 Me.OptionButton2.Visible = Not Me.CheckBox1 End Sub -- --- Regards, Norman "Rmagic" wrote in message ... Hello I have a user form With a couple of option buttons and check boxe and command button Is it poss to make the option buttons unload then selfs and fade out (Stop working) if the check box is seleted eg option 1= wood option 2= metal if checkbox is ticked the 2 above unload (both become false and not able to selet them unitl the checkbox is unticked ) hope makes sense Thanks -- Rmagic ------------------------------------------------------------------------ Rmagic's Profile: http://www.excelforum.com/member.php...o&userid=28595 View this thread: http://www.excelforum.com/showthread...hreadid=484511 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forms - Checkboxes | Excel Worksheet Functions | |||
creating checkboxes from forms tool bar | Excel Worksheet Functions | |||
Checkboxes from the Forms Toolbar | Excel Programming | |||
Forms control checkboxes on charts | Excel Programming | |||
Can you hide forms checkboxes | Excel Programming |