Passing In Arguments
It is possible to pass information to a userform however you cannot use the Userform_Initalise event.
The Userform_Initailize event does not allow arguments to be passed to it.
There are a number of different ways you can work around this.
Which one you use will depend if you want to use the argument in the Initialise event.
Used in the Initialise - Global Variable
Global variable
Used after Initialise - Userform Property
Creating a userform property is the best approach because it means that your code is self-contained (encapsulation principles)
Alternatives
Using Tag property
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext