Results 1 to 6 of 6

Changing Cell color?

Threaded View

xmux Changing Cell color? 03-26-2009, 04:37 AM
royUK Re: Changing Cell color? 03-26-2009, 04:42 AM
xmux Re: Changing Cell color? 03-26-2009, 04:45 AM
xmux Re: Changing Cell color? 03-26-2009, 05:20 AM
royUK Re: Changing Cell color? 03-26-2009, 05:28 AM
xmux Re: Changing Cell color? 03-26-2009, 06:14 AM
  1. #1
    Registered User
    Join Date
    09-22-2008
    Location
    vienna
    MS-Off Ver
    MS Office 2007
    Posts
    24

    Changing Cell color?

    Hi,

    I have a code that check the String on the cell! But if it is wrong i wanna make the cell Red colored?

    If Selection.Cells(x, 14) <> "A" And Selection.Cells(x, 14) <> "B" And Selection.Cells(x, 14) <> "C" And Selection.Cells(x, 14) <> "D" And Selection.Cells(x, 14) <> "L" And Selection.Cells(x, 14) <> "N" And Selection.Cells(x, 14) <> "S" And Selection.Cells(x, 14) <> "T" Then
        MsgBox "Type is False! You have to change it! " & "Place: Selected Row: " & x & " Column: 14 (N)"
        GoTo Einde
        End If
    Thanks
    Last edited by xmux; 03-26-2009 at 06:15 AM.

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