Assigning a UserForm Name to a Variable

Adventures in VBA

Assigning a UserForm name to a variable can be useful where you have more than one userform performing the same or similar actions. You can Set the variable in the user form module and pass it as an argument to the subroutine where the main code is housed.

View original post 81 more words