Userforms Show and Unload with variables

[Rick S.]

How can I Show and or Unload a userform with variables?

Example:
frm = "MyForm"
frm.show
or
Unload frm

The above code fails as "Invalid Qualifier".
Reading "Invalid Qualifier" from the help file is not helping. LOL
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007

 

[Chip Pearson]

I have code at http://www.cpearson.com/Excel/ShowAnyForm.htm that allows you
to do this. The page contains a function that you can use as-is (you pass in
the name of the form as a String along with the modal option as a Long) or
you can adapt the function to your specific needs.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Rick S.]

Thank you!
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007