Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't call a sub in a UserForm using Application.Run
I'm having problems calling Public Sub XXX that is in Userform1.
Tried Application.Run "Userform1.XXX" but will not work. Works OK if XXX is in a Standard Module, Thanks for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't call a sub in a UserForm using Application.Run
Is the userform loaded? You aren't suppose to call user form routine dirrectly. If yo have common code move the macro from the userform to a module and then call the routine.. You can call the common code from a userform, right! -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=181173 Microsoft Office Help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't call a sub in a UserForm using Application.Run
Try:
Call userform1.xxx (with userform1 loaded/shown) Mike wrote: I'm having problems calling Public Sub XXX that is in Userform1. Tried Application.Run "Userform1.XXX" but will not work. Works OK if XXX is in a Standard Module, Thanks for any help. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't call a sub in a UserForm using Application.Run
It doesn't matter if it's loaded or not.
Dave Peterson wrote: Try: Call userform1.xxx (with userform1 loaded/shown) Mike wrote: I'm having problems calling Public Sub XXX that is in Userform1. Tried Application.Run "Userform1.XXX" but will not work. Works OK if XXX is in a Standard Module, Thanks for any help. -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't call a sub in a UserForm using Application.Run
It appears that Application.Run can be in a Standard Module, a Class Module
or a Userform module and it cannot call a sub in a Userform Module. Thanks. "joel" wrote in message ... Is the userform loaded? You aren't suppose to call user form routine dirrectly. If yo have common code move the macro from the userform to a module and then call the routine.. You can call the common code from a userform, right! -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=181173 Microsoft Office Help |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't call a sub in a UserForm using Application.Run
The reason I have to use Application run is because I need the XXX to be a
variable, like 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" wrote in message ... Try: Call userform1.xxx (with userform1 loaded/shown) Mike wrote: I'm having problems calling Public Sub XXX that is in Userform1. Tried Application.Run "Userform1.XXX" but will not work. Works OK if XXX is in a Standard Module, Thanks for any help. -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't call a sub in a UserForm using Application.Run
The Call userform1.xxx does work but "Call" can't take a variable.
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" wrote: The reason I have to use Application run is because I need the XXX to be a variable, like 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" wrote in message ... Try: Call userform1.xxx (with userform1 loaded/shown) Mike wrote: I'm having problems calling Public Sub XXX that is in Userform1. Tried Application.Run "Userform1.XXX" but will not work. Works OK if XXX is in a Standard Module, Thanks for any help. -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't call a sub in a UserForm using Application.Run
Thanks Chip. That's exactly what I need. Works great!!
"Chip Pearson" wrote in message ... The Call userform1.xxx does work but "Call" can't take a variable. 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" wrote: The reason I have to use Application run is because I need the XXX to be a variable, like 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" wrote in message ... Try: Call userform1.xxx (with userform1 loaded/shown) Mike wrote: I'm having problems calling Public Sub XXX that is in Userform1. Tried Application.Run "Userform1.XXX" but will not work. Works OK if XXX is in a Standard Module, Thanks for any help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call Search Application | Excel Programming | |||
Failure with Excel.Application Call | Excel Programming | |||
Call procedure using Application.Run | Excel Programming | |||
Application.Run Call Err: 1004 Cannot Find Macro | Excel Programming | |||
Call other application from excel | Excel Programming |