Results 1 to 7 of 7

Conditional formatting using VBA

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Cologne, Germany
    MS-Off Ver
    Excel 2010
    Posts
    156

    Question Conditional formatting using VBA

    I must confess that I’m really getting out of my depth here. I am VERY new to VBA and I just have no idea how to solve an issue so any suggestions more than welcome! I have the following syntax;

    Private Sub CheckBox1_Click()
    If CheckBox1 = True Then
    Range("B4:G5") = format this range to fill the cells with light grey
    ElseIf CheckBox1 = False Then
    Range("B4:G4") = do nothing
    End If
    End Sub

    As you can see, I have created a simple check box that when checked should ‘grey out’ or fill in the range of cells light grey. If unchecked, then it should just leave the information in those cells ‘as is’, which is a combination of user input and formula.
    Last edited by kborgers; 03-02-2010 at 06:53 AM. Reason: misleading title

Thread Information

Users Browsing this Thread

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

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