When I click on a command button and a Macro runs and a window pops up asking me to enter data, if I click on CANCEL, I will get an error window box and then a HALT window... is there anyway and HOW/where can I avoid these windows and instead give my own message box or go to another button??

Thanks

You could do a little VB coding. Are you up for that?