Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
click/unclick a box and make other info. appear?
I am trying to make it to where I click a box and then it has other
information appear, as to whatever I click. Kind of like a flow chart. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
click/unclick a box and make other info. appear?
Maybe this will help: Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Range("A1").Value = "This check box has been checked" Else Range("A1").Value = "This check box has been unchecked" End If End Sub -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=548610 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
click/unclick a box and make other info. appear?
Here is another option Private Sub CheckBox1_Click() If CheckBox1.Value = True Then CheckBox1.Caption = "This Checkbox has been checked" Else: CheckBox1.Caption = "This Checkbox has been unchecked" End If End Sub -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=548610 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
click/unclick a box and make other info. appear?
I'm really new at this, but if I get the checkbox from the forms section, I
don't know how to add the code in there. However, if I get it from the control toolbox, I can edit the code, but am not able to click/unclick it? Any suggestions there? "Bearacade" wrote: Here is another option Private Sub CheckBox1_Click() If CheckBox1.Value = True Then CheckBox1.Caption = "This Checkbox has been checked" Else: CheckBox1.Caption = "This Checkbox has been unchecked" End If End Sub -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=548610 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
click/unclick a box and make other info. appear?
Goto View, Toolbars, Control Toolbox Design Mode is the toggle, If you are in Design mode, you can go into the code and stuff. When you are out of it. You can "click" it -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=548610 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|