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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 04:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com