Hi
Im in the process of designing a form in excel which captures certain fields and then inputs the data into the relevant places on a spreadsheet running in the background.
My problem is that when i check for errors, e.g. a blank field ...
*****
Select Case busname
Case ""
MsgBox "The required field 'Business Trade Name' is empty."
End Select
*****
After the user clicks "ok" to get rid of the MsgBox the rest of the code is executed. I've tried putting a "stop" in but this jumps into the code.
My question: is there a way of pausing the process here so that the other correct values entered into form can remain intact allowing the user to correct the necessary field and then click the "submit" button again once they're finished.
Any ideas and suggestions would be greatly appreciated
Thank you
Steve
Im in the process of designing a form in excel which captures certain fields and then inputs the data into the relevant places on a spreadsheet running in the background.
My problem is that when i check for errors, e.g. a blank field ...
*****
Select Case busname
Case ""
MsgBox "The required field 'Business Trade Name' is empty."
End Select
*****
After the user clicks "ok" to get rid of the MsgBox the rest of the code is executed. I've tried putting a "stop" in but this jumps into the code.
My question: is there a way of pausing the process here so that the other correct values entered into form can remain intact allowing the user to correct the necessary field and then click the "submit" button again once they're finished.
Any ideas and suggestions would be greatly appreciated
Thank you
Steve