Hello,
Leith Ross showed me the other day a way of identifying the UserForm control in focus through the function:
I’d like to take a step further and pass parameters to a class module and depending on which control (CommandButton) is pressed, take a different action.
I have in the Initialize section of the multipage UserForm:
and in the NavBtnClass class module
Is it possible to pass a parameter to the class module changing the Multipage1.Value?
If I put a value in the Button Tag property I can use f.i. myTag=Right(Ctrl.Tag,1) to extract
the MultiPage number I want this particular Button to direct me to, but I don’t know how to pass this parameter to the class module!
Regards
Mats
Bookmarks