Calling a Userform from a Predefined Variable

H

Hendy88

Hello to all,

In my code, I have a variable that represents the name of a UserForm
that will be opened as a result of a call to a function. However,
what I have errors out with "this object does not support this
property or method". How can I open the appropriate existing form
based on this string representing the form name?

This is what I currently have:

Dim FormName As String

FormName = "FieldUserForm"
FormStuff FormName

Function FormStuff(FormName As String)
With FormName
.Show
.Textbox1.Visible = False
.Textbox2.Visible = False
.Textbox3.Visible = True
.Textbox4.Visible = False
.Textbox5.Visible = True
End With
End Function


I've tried even making the Dim variable "As UserForm" but that didn't
work either. Any ideas? Or should I be going about this a different
way? Reason I want the separate function is because there are more
than one UserForms that I want to show at different stages in the
macro. So later on I want to call the same function with a different
UserForm name:

FormName = "OfficeUserForm"
FormStuff FormName


Thanks in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Use a variable in a ShapeRange.Increment 0
Select Text to End of Footnote 9
How do I set focus (and select text) on a text box on a modeless userform? 0
Defining UserForm Caption from a Variable 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Macro to Select text from a point given to a specific word 2
Change a great number of words in word files, with a macro as short as possible. 5

Top