MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I need an expert on Input Boxes

Posted by Rees Macleod on June 29, 2000 10:19 PM

I have a macro that asks for many user defined values gathered from InputBoxes. If an error is made in one of the boxes it would be nice if they could cancel the entire macro and start over. The problem I have is that many of the input values are integers and I cannot use the vbcancel value of 2 as a signifier to end the procedure because they may very well want to use the actual value of 2 in their worksheet.

Thanks for any help,


Posted by Rees Macleod on July 01, 0100 12:29 AM

Hi Ryan,

Thanks for your response, but I figured it out about 2 hours later. All I needed to realize was that if a user hits the cancel button, it returns a null value.

With that I was able to instruct the code to do what I needed.

Thanks again. I am going to post another question, however, about user forms. Perhaps you may have heard of this particular problem.


Posted by Ryan on June 30, 0100 6:48 PM

Post the code so people can take a look at it and see what's going on. I'll be glad to help!