Hi
try
If Not IsDate(A) or Not IsDate(B) or Not IsDate(C) then
Msgbox "Enter Date"
end if

--
Regards
Frank Kabel
Frankfurt, Germany

Uddinj1 wrote:
Hi All,

I am trying to write a statement like

if A or B or C is not date then
Msgbox "Enter Date"

I can do individual ones like
if isdate(A)=false then
msgbox "Enter date"

How do I make one statement to cover all three or more conditions?

Thanks for you help.

Regards

UJ