I have just created a userform and have declared the variable as
and the value is set like thisPlease Login or Register to view this content.
Now I used Application.Run as this is a module that I use in multiple Excel spreadsheets and I did not want to move all the syntax within the user form itself (if possible). Now in this procedure if I do a Debug.Print the value of emp is empty?Please Login or Register to view this content.
Why does the variable loose its value even though it has been declared as public?Please Login or Register to view this content.
Bookmarks