Producing warnings

[Frankie needs HELP]

How do I produce a warning that tells the user of the database that no patients have been admitted?

My spreadsheet contains 7 columns. Column E is the admitted column with the dates that the patients were admitted.

How do I produce an If Statement so that when my macro runs if non of the patients have been admitted a warning will appear?

 

[Juan Pablo González]

Not sure, but, do you check if any patients have been admited depending on today's date ? or yesterday ?

Or do you want to look in Column E and see if there is anything there ?

 

[Dave Hawley]

Hi Frankie


How about

If WorksheetFunction.CountA(Columns(5) = 0) Then
MsgBox "No Patients", vbCritical
Exit Sub
End If

 

[Frankie needs HELP]

It's not working a mis match error appears. Am I doing something wrong? Is there something I will have to change?

 

[Frankie needs HELP]

Juan, yes it is column E I want to look at

 

[Cosmos75]

EDIT: Deleted posted answer to wrong question
This message was edited by Cosmos75 on 2002-04-10 13:54