how to use if condition to check whether checkbox is checked

**Bronx** · 05-12-2016, 01:20 AM

I have created two checkbox from the control toolbox and a form button, the checkbox is place beside each row of data. When the button clicked while the checkbox is checked, that row of data is formatted into the body of the email. I tried using this code that I found on online, but it shows run-time error '1004'.

Please Login or Register  to view this content.

This is my code

Please Login or Register  to view this content.

**cytop** · 05-12-2016, 01:39 AM

What's 'l'? Where is it declared or assigned a value, or do you really have checkboxes named 'CheckBox-3' & 'CheckBox-4'?

**Bronx** · 05-12-2016, 02:00 AM

Thanks for your reply cytop. The 'l' is where the checkbox are, so there is a checkbox at "L3" and another at "L4".
I got the code from http://stackoverflow.com/questions/30502202/send-email-if-check-box-is-checked"]here

**bulina2k** · 05-12-2016, 02:09 AM

Hi there!
ActiveSheet.OLEObjects("Checkbox" & l - 3).Object.Value should contain the name of the checkbox object not its position.
So in your example if the checkbox name is "Checkbox1" then the code should look like

Please Login or Register  to view this content.

hth.

**cytop** · 05-12-2016, 02:15 AM

You are using an undeclared variable called 'l' (upper case for clarity - 'L')

As it is undeclared, it will assume a value of 0 or 'Empty' depending on how it is used. The iine

Please Login or Register  to view this content.

will force l to a value of 0 so that line is looking for a checkbox named 'Checkbox-3'

You need to replace the calculated name with the actual name of the checkbox. You can get this by right clicking on the chckbox and looking at the Name box to the left of the Formula bar above the worksheet and edit the line like

Please Login or Register  to view this content.

Where 'Checkbox1' is the actual name of the checkbox.

There are 2 lines to edit.

To prevent errors like this you should use the

Please Login or Register  to view this content.

directve at the top of each code module. This will raise a compile error if there are any undeclared variables. See http://www.cpearson.com/excel/declaringvariables.aspx for details.

**Bronx** · 05-12-2016, 02:39 AM

Thanks bulina that fixed the error.

**Bronx** · 05-12-2016, 02:45 AM

Originally Posted by cytop

You are using an undeclared variable called 'l' (upper case for clarity - 'L')

As it is undeclared, it will assume a value of 0 or 'Empty' depending on how it is used. The iine

Please Login or Register  to view this content.

will force l to a value of 0 so that line is looking for a checkbox named 'Checkbox-3'

You need to replace the calculated name with the actual name of the checkbox. You can get this by right clicking on the chckbox and looking at the Name box to the left of the Formula bar above the worksheet and edit the line like

Please Login or Register  to view this content.

Where 'Checkbox1' is the actual name of the checkbox.

There are 2 lines to edit.

To prevent errors like this you should use the

Please Login or Register  to view this content.

directve at the top of each code module. This will raise a compile error if there are any undeclared variables. See http://www.cpearson.com/excel/declaringvariables.aspx for details.

Thanks for the advice and help!

**bulina2k** · 05-12-2016, 02:47 AM

I'm glad I could help. Thanks for the rep point.
Cytop is right you know.. You should use variable declaration to avoid this kind of errors in the future.
The mode to enable variable declaration requirement is to check the -=Tools-Option-[Editor] tab - Require Variable Declaration=- checkbox in the VBA Menu.
...don't forget to have fun!

how to use if condition to check whether checkbox is checked

LinkBack

Thread Tools

Rate This Thread

Display

how to use if condition to check whether checkbox is checked

Re: how to use if condition to check whether checkbox is checked

Re: how to use if condition to check whether checkbox is checked

Re: how to use if condition to check whether checkbox is checked

Re: how to use if condition to check whether checkbox is checked

Re: how to use if condition to check whether checkbox is checked

Re: how to use if condition to check whether checkbox is checked

Re: how to use if condition to check whether checkbox is checked

Thread Information

Users Browsing this Thread

Similar Threads

How to check if excel file is Checked Out in SharePoing Check Out, run code, Check In

For each checkbox on userform, if checked, set "t" & (the check boxes name) = true

Check Box that shows options in Combo Box if Checked, and Hides if Not Checked

[SOLVED] When checkbox is checked it does not copy to new sheet. Only if not checked using false

Automatically check one or more check boxes when a parent check box is manually checked

[SOLVED] VBA code to uncheck checkbox 2 & 3 if checkbox 1 is checked

[SOLVED] Check box (control form) checked or not - must be a simple way to test if box checked

Bookmarks

Bookmarks

Posting Permissions