Simple MSG Box Macro

[smartguy]

Hello all,

I am looking for Simple MSG box macro.

If B2 field is null i need msg box.

I tried the below code but it is not working.

Sub check()
If B2 = "" Then
MsgBox "b2 value is null"
End If
End Sub

 

[Arul.rajesh]

Hello all,

I am looking for Simple MSG box macro.

If B2 field is null i need msg box.

I tried the below code but it is not working.

Sub check()
If B2 = "" Then
MsgBox "b2 value is null"
End If
End Sub

[/CODE]

Try This

Sub check()
If [B2] = "" Then
MsgBox "b2 value is null"
End If
End Sub

 

[VoG]

Or

Sub check()
If Range("B2").Value = "" Then
    MsgBox "b2 value is null"
End If
End Sub

 

[Silvrhelm]

This should work, you just need to add in the range property

Sub b2null()
    If Range("B2") = "" Then
        MsgBox "B2 is null"
    End If
End Sub

Hope this helps

 

[villy]

You can try:

Sub cnull()
If Len(Range("B2")) = 0 Then MsgBox "This is null"
End Sub

 

[Arul.rajesh]

Samrtguy,
You have to refer to the value of the cell B2 in the if function.

Look for "Referring to ranges."