Conditional Message Box

[danchu1]

Hi, thanks for all help in advance!

I need help writing a script in VBA which is conditional on an active cell being either blank or with characters

i.e if specific cell (A1) is blank then Message Box appears otherwise do nothing

Thanks!

 

[Andrew Poulsom]

Welcome to MrExcel.

Example:

If Range("A1").Value = "" Then
    MsgBox "Blank"
End If

 

[danchu1]

Thanks, but its not generating the Message Box, do i need to run a macro on the cell ?

 

[L. Howard]

I'm guessing Andrew presumed you would know to do this.
Name the sub whatever you want
Copy and paste in the sheet module. You can assign it to a button to run.

If you want it to run by its self, post back and we can put it in an event macro.

Option Explicit

Sub Danchu1()
If Range("A1").Value = "" Then
    MsgBox "Blank"
End If
End Sub

Howard

 

[danchu1]

Thank you, yes I'd like to know how to make it run by itself in an event macro.

Really appreciate your help

 

[L. Howard]

Copy and paste in the sheet module.

Change B1 in any manner, type an "X" into it and you will get the message box. Now delete the "X", see message again.
Put an "X" in A1 and do the same routine with B1. No message boxes.

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$B$1" Or Target.Cells.Count > 1 Then Exit Sub
If Range("A1").Value = "" Then
    MsgBox "Blank"
End If
End Sub

There are many Worksheet_Event macros already named and stored in the sheet VBA Editor.

Howard

 

[danchu1]

Hmm, not working

Sorry to be a pain

The active cell is u59 if the cell is blank, then a message box should appear, if it is not blank then the message box should not.

Will be looking for classes on Excel VBA, if you can recommend any in NYC it would be great

Thanks,
danchu1

 

[L. Howard]

Then go back to Andrews original post and my follow up. Change A1 to U59.

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("U59").Value = "" Then
    MsgBox "Blank"
End If
End Sub

Don't know any classes in NYC, but you could google "Excel vba code classes New York City".

I would suspect you would get huge list.

Howard