I am stumped again by what is probably a simple problem.
I'm trying to get a variable onto a userform in Personal.xlsb which triggers when the user clicks on a hyperlink that's created by another macro.
I've declared a public variable:
And then when the hyperlink is clicked this code runs. The MsgBox shows the variable correctly at this point:
The sub "showmyform" is as follows, and again the MsgBox shows the variable correctly here:
Then the following in UserForm1. The MsgBox here is blank.
If anyone has any ideas I'd really appreciate it.
Bookmarks