Restarting a macro

Out of category
1

Hello

I'm currently working on a macro, in it, I bring up an error message if the values entered don't match . I would like to be able to restart my macro from the beginning with a button, how can I do it?

Thanks in advance

 

2

Maybe with the goTo function.

https://docs.microsoft.com/fr-fr/office/vba/language/reference/user-interface-help/goto-statement

Or recall the sub with the call function

https://docs.microsoft.com/fr-fr/office/vba/language/concepts/getting-started/calling-sub-and-function-procedures

To be adapted according to your needs

 

2 Likes
3

Great thank you very much it works now. I had also forgotten to hide the old UserForm so I had error messages but now it works thank you.