Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: What's the VBA way to say IF ISBLANK

  1. #1
    Board Regular Chris The Rock's Avatar
    Join Date
    Feb 2002
    Location
    Longmont, CO
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want a msgbox to pop up if the ActiveCell is blank...
    How do I say this?

    I tried
    IF ActiveCell.Value = Null Then
    Msgbox ("My message") ...

    but this did not work.
    "Never go in against a Sicilian when death is on the line!"

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    try if = ""

  3. #3
    Board Regular Chris The Rock's Avatar
    Join Date
    Feb 2002
    Location
    Longmont, CO
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm still interested, but I got it to work using
    If ActiveCell.Value = "" Then
    MsgBox....
    "Never go in against a Sicilian when death is on the line!"

  4. #4
    Board Regular Chris The Rock's Avatar
    Join Date
    Feb 2002
    Location
    Longmont, CO
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Must have been typing when you posted that, tk19. Thanks!
    "Never go in against a Sicilian when death is on the line!"

  5. #5
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-15 12:56, Chris The Rock wrote:
    I want a msgbox to pop up if the ActiveCell is blank...
    How do I say this?

    I tried
    IF ActiveCell.Value = Null Then
    Msgbox ("My message") ...

    but this did not work.

    Try the following:
    IF ActiveCell.Value = "" Then
    Msgbox ("My message") ...
    end if

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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