Skip MsgBox if found error

Hi,

Using Global Variable declaration and 2 sub functions, I am able to skip MsgBox if the call Macro name has triggered error message. However when call macro name has been transferred to UserForm platform, it will be no longer applicable due to variable (FindWhom) in UserForm has not recognized in the Module (Main Sub). The main purpose of using UserForm is to create progress indicator

Is there any alternative method? Here is a simple description of my problem..

Please Login or Register  to view this content.

Hi,

Have you tried declaring it as a Public variable?

Hi Richard,

I have tested and it working fine

In a proper manner, public variable supposed to be declared in the Main Sub or UserForm or both?

or if without using this method, any best alternative method to skip MsgBox for such problem

Hi,

By its very nature a Public variable can't be displayed in a procedure it needs to be placed at the Module level.
You can also choose to pass a value when you call another procedure and use that value in a variable that's declared in the second procedure.

i.e.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

If you're interested in the full War and Peace story on the scope of variables then see here...https://support.microsoft.com/en-gb/kb/141693

Hi,

Thank you sir.