Tick checkbox if a certain cell is not empty.

**jazzy747** · 11-12-2012, 04:38 AM

Hello everyone,

Thanks for this awesome forum!

I am new to here and also to VBA. What I am looking for is a way to have a checkbox automatically ticked (CheckBox6.Value = True) if a certain cell is not empty.
To be more precise, it is a form where you choose different options by ticking checkboxes and then enter a money amount in the cells next to the boxes. I cannot link the cells to the boxes because they are already linked to other cells. So I am looking for a formula that looks like this, but I am missing the first part and the correct syntax:

Private Sub ???????
If CELL G 33 = NOT EMPTY?? then
CheckBox6.Value = True
End If
End Sub

I thank you in advance if you could help me with this!
Cheers

**jazzy747** · 11-12-2012, 11:08 AM

Hello again,

If my request is not complete enough I am willing to give more details in order to enable someone to help me.
Please someone help me!

**watersev** · 11-12-2012, 11:22 AM

hi jazzy747, the posted workbook sample is better than thousands of words ...It would be helpful if you can provide one

**jazzy747** · 11-12-2012, 11:48 AM

Thanks watersev, here’s the document.

It is a form that clients will have to fill out. Most of the cells will be blocked. Users can tick boxes and enter $ amounts in column “G”.
Since column “I” is only calculating when the boxes are ticked, I would like to have the checkbox automatically ticked when the user enters a number in column “G” without actually ticking the box. This enables sort of a shortcut (you don’t have to go through the step “check the box”).

Is this information clear enough?
Thanks in advance for taking a look at it.

**6StringJazzer** · 11-12-2012, 02:29 PM

Here is a solution. [jazzy747=CheckBoxes-Forum.xlsm] Great username.

This solution takes advantage of the fact that you link, the checkboxes to other cells on the same row as your amounts. The code you were looking for is:

Please Login or Register  to view this content.

**watersev** · 11-12-2012, 05:21 PM

different option, no linked cells in L column, no formulas

**jazzy747** · 11-12-2012, 05:43 PM

Many thanks to both of you, I'll have a look at your solutions tmw at work.

Thanks for taking time for this!

Tick checkbox if a certain cell is not empty.

LinkBack

Thread Tools

Rate This Thread

Display

Tick checkbox if a certain cell is not empty.

Re: Tick checkbox if a certain cell is not empty.

Re: Tick checkbox if a certain cell is not empty.

Re: Tick checkbox if a certain cell is not empty.

Re: Tick checkbox if a certain cell is not empty.

Re: Tick checkbox if a certain cell is not empty.

Re: Tick checkbox if a certain cell is not empty.

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions