Message box if cell is left empty when run?
 

Right now I have 2 cells in the top left of my spreadsheet that are se
to be parameters. One is the start date and one is the end date.
would like to know if there is a way to have a message box come up i
someone tries to run the macro without having a date in the box
instead of having it error out.

I know there is a way and it would be an If statement, but not sure ho
it would be written.

Thanks,

~

--
nbaj2
-----------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...fo&userid=3648
View this thread: http://www.excelforum.com/showthread.php?threadid=56698

Message box if cell is left empty when run?
 

say range 1 and 2 are on Sheet1, "A1" and "A2"...

'Check for start date
If Sheet1.Range("A1") = "" OR (Not IsDate(Sheet1.Range("A1")) then
'Flag message and exit routine
end if

Then do same for end date.

nbaj2k wrote:
Right now I have 2 cells in the top left of my spreadsheet that are set
to be parameters. One is the start date and one is the end date. I
would like to know if there is a way to have a message box come up if
someone tries to run the macro without having a date in the box,
instead of having it error out.

I know there is a way and it would be an If statement, but not sure how
it would be written.

Thanks,

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=566989

Message box if cell is left empty when run?
 

thanks! exactly what I needed.

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=566989