Criteria not met error message

[Jamie]

Hi There

I have a few buttons that run macros in my spreadsheet. I am trying to work
out how I can display an error message if certain criteria on the sheet is
not met.

E.g If say A3 is blank I would want an error message saying please fill in
A3 or something like that.

Any help would be greatly appreciated

Thanks in advance

Jamie

 

[Frank Kabel]

Hi
try something like
if activesheet.range("A3")="" then
msgbox "Fill cell A3"
end if