Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Location
    Indiana
    Posts
    7

    Unanswered: Shading cell with VBA

    ok I know some of the code this will happen on a click event of a button:

    Dim MyRange as Range
    Dim c As Range

    Set MyRange = ("B2:FN134)
    For each c in MyRange
    IF (<cell color>) = (<white>) then (<cell color>) = (<yellow>)
    Next C

    For all things in < > in need to know the syntax of the code to write this in VBA

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    perhaps:

    Code:
    If c.Interior.Color = vbWhite Then c.Interior.Color = vbYellow
    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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