What's the VBA way to say IF ISBLANK

[Chris The Rock]

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.

 

[tk19]

try if = ""

 

[Chris The Rock]

I'm still interested, but I got it to work using
If ActiveCell.Value = "" Then
MsgBox....

 

[Chris The Rock]

Must have been typing when you posted that, tk19. Thanks!

 

[Al Chara]

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