Is it possible to put a customised message when error occur anywhere in USERFORM

Dear all,

I have a Vba UserForm with many textboxes and comboboxes

when some error occurs anywhere through out the UserForm code then the userform throws error and on pressing end or debug, you will have to start from zero.

I want solution like this:
If error occurs at TextBox1 it will ignore that error and will go to TextBox2 and so on.

I am using on Exit(ByVal Cancel As MSForms.ReturnBoolean) at some place. But it is not possible to identify what kind of error end user will make while using my UserForm

So, I need a code at the top of UserForm Code which will operate when any error occur anywhere in code and allow user to go to next

Hi vatsalgos,

You can use "On Error Resume Next" but I prefer to make the code of the UserForm more robust to eliminate the errors. Can you post a sample of your file which contains the UserForm to see the code & members can suggest some revisions to the code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

For full Userform there are about 50 such instances

What happens is like this :
If user accidentally enter the text in place of number in TextBox9110, obviously TextBox9111 will fail

Such type of instances can be managed at each code, but I want few lines at the top by which UserForm will not close at the error