What's the VBA way to say IF ISBLANK

Chris The Rock · Mar 15th, 2002, 01:56 PM

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 · Mar 15th, 2002, 02:01 PM

try if = ""

Chris The Rock · Mar 15th, 2002, 02:01 PM

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

Chris The Rock · Mar 15th, 2002, 02:02 PM

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

Al Chara · Mar 15th, 2002, 02:02 PM

Quote:

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

Mar 15th, 2002, 01:56 PM	#1
Chris The Rock Board Regular Join Date: Feb 2002 Location: Longmont, CO Posts: 279	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!"

Mar 15th, 2002, 02:01 PM	#3
Chris The Rock Board Regular Join Date: Feb 2002 Location: Longmont, CO Posts: 279	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!"

Mar 15th, 2002, 02:02 PM	#4
Chris The Rock Board Regular Join Date: Feb 2002 Location: Longmont, CO Posts: 279	Must have been typing when you posted that, tk19. Thanks! __________________ "Never go in against a Sicilian when death is on the line!"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 02:01 PM	#2
tk19 New Member Join Date: Mar 2002 Posts: 33	try if = ""