Userforms Show and Unload with variables

  • Thread starter Thread starter Rick S.
  • Start date Start date
R

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
 
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)
 
Back
Top