Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Checkboxes to enable/disable vb
I'm running a macro and trying to have parts of the code run or not run
depending on whether various checkboxes are checked. The checkboxes are from the Forms toolbar, and they all reference cells in column L Basically this is what I have.. If Sheet1.Cells(12, 7).Value = "TRUE" Then (I've tried of variations of referencing the cell) ....code... and just for good measure in the Else portion I've put Sheet1.Range("E7") = [L7].Value And of course L7 reads TRUE when I run the macro. Thanks in advance Paul Salama |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Checkboxes to enable/disable vb
I am not certain if this will help with your problem. But I created a blank **** and a checkbox and put the following code in it: Sub test() If CheckBox1.Value = "True" Then MsgBox ("True") Else If CheckBox1.Value = "False" Then MsgBox ("False") End If End If End Sub It also works if you are referencing a cell's value. -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=551920 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Checkboxes to enable/disable vb
Try removing the double quotes:
If Sheet1.Cells(12, 7).Value = True Then wrote: I'm running a macro and trying to have parts of the code run or not run depending on whether various checkboxes are checked. The checkboxes are from the Forms toolbar, and they all reference cells in column L Basically this is what I have.. If Sheet1.Cells(12, 7).Value = "TRUE" Then (I've tried of variations of referencing the cell) ...code... and just for good measure in the Else portion I've put Sheet1.Range("E7") = [L7].Value And of course L7 reads TRUE when I run the macro. Thanks in advance Paul Salama -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Checkboxes to enable/disable vb
Thanks a lot. it seems that the capitalization made a difference. so
matching on "True" worked, but not "TRUE"... Even though the actual text is capitalized. so this is what worked: If Sheet1.[L7].Value = "True" Then ....code... Thanks again. Paul |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Checkboxes to enable/disable vb
Did removing the double quotes work when you tried it?
Paul wrote: Thanks a lot. it seems that the capitalization made a difference. so matching on "True" worked, but not "TRUE"... Even though the actual text is capitalized. so this is what worked: If Sheet1.[L7].Value = "True" Then ...code... Thanks again. Paul -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Checkboxes to enable/disable vb
Oddly enough it didn't
Dave Peterson wrote: Did removing the double quotes work when you tried it? Paul wrote: Thanks a lot. it seems that the capitalization made a difference. so matching on "True" worked, but not "TRUE"... Even though the actual text is capitalized. so this is what worked: If Sheet1.[L7].Value = "True" Then ...code... Thanks again. Paul -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Checkboxes to enable/disable vb
It worked ok for me when I tested.
Paul wrote: Oddly enough it didn't Dave Peterson wrote: Did removing the double quotes work when you tried it? Paul wrote: Thanks a lot. it seems that the capitalization made a difference. so matching on "True" worked, but not "TRUE"... Even though the actual text is capitalized. so this is what worked: If Sheet1.[L7].Value = "True" Then ...code... Thanks again. Paul -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable/Disable Macro Pop-Up | Excel Discussion (Misc queries) | |||
Enable/Disable Macros Pop-Up | Excel Discussion (Misc queries) | |||
Enable/Disable Macros | Excel Discussion (Misc queries) | |||
How to enable/disable a button. | Excel Programming | |||
Enable/Disable Macros | Excel Programming |