Tried
Application.Run "Userform1.XXX"
but will not work. Works OK if XXX is in a Standard Module,
Thanks for any help.
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=181173
[url="http://www.thecodecage.com"]Microsoft Office Help[/url]
(with userform1 loaded/shown)
--
Dave Peterson
--
Dave Peterson
dim zzz as string
zzz= "Userform1.xxx"
Application.Run zzz
The Call userform1.xxx does work but "Call" can't take a variable.
Thanks Peter
"Dave Peterson" <pete...@verizonXSPAM.net> wrote in message
news:4B813354...@verizonXSPAM.net...
Use CallByName. E.g., in a regular code module
Sub AAA()
Dim FF As UserForm1
Dim S As String
S = "HelloWorld"
Set FF = New UserForm1
CallByName FF, S, VbMethod
End Sub
Here, HelloWorld is a method defined in UserForm1's code module. You
need to create an instance of UserForm1 but you need not Show the form
to make it visible.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
On Sun, 21 Feb 2010 06:29:05 -0800, "Mike" <mike...@hotmail.com>
wrote:
"Chip Pearson" <ch...@cpearson.com> wrote in message
news:hnh2o5hvoii9hphs5...@4ax.com...