Results 1 to 6 of 6

Thread: Advice: Help with Msgbox

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 06-21-2004, 08:45 AM #2
    Zack Barresse
    Zack Barresse is offline
    Site Admin
    Urban Myth
     VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Hi Hesham,

    What color is this:

    If c.Interior.ColorIndex <> -4142 Then
    Not sure what that's for, but what color are you looking for here before you check the value of each cell?

    And you may want to check out the VBA tags when you post, it will make your code appear very legible, clear and concise.
    Last edited by Anne Troy; 06-21-2004 at 08:56 AM.
    Regards, Zack Barresse

    Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
    What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules