Results 1 to 7 of 7

Tick checkbox if a certain cell is not empty.

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    Lasuanne
    MS-Off Ver
    Excel 2010
    Posts
    7

    Tick checkbox if a certain cell is not empty.

    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
    Last edited by jazzy747; 11-12-2012 at 04:59 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1