Or statement

[Uddinj1]

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

 

[Frank Kabel]

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

 

[Uddinj1]

Frank,

Thank you for your help.

Regards
UJ

 

[onedaywhen]

Or:

if not(IsDate(A) and IsDate(B) and IsDate(C)) then

--