Error check for Start date & End date in a macro

[kmahesh]

Hello everyone,

I have attached an excel file which contains a macro.
What i am trying to do is this:
When i run the macro it will ask for Start date and End date .
Then it will delete all rows for dates < Start date and > End date.
Till here it is working fine.

Problem is :
I want to do error check ie.
if the user keeps the Start date or End date blank
OR
if End date < Start date
OR
if CANCEL button is clicked

what should be done ?

Pls help

Regds
Kmahesh

[haripopuri]

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

[kmahesh]

Thanks Haripopuri & Patel45 ,
both the solutions are working

[haripopuri]

Glad we could help. You might consider showing your respect to the person who helped you by clicking on star button at the bottom of the post.