How to open UserForm code by VBA?

Sbirro Cornuto · Mar 19th, 2002, 01:04 PM

'Sup?
How can I open the UserForm code module by macro. Like when I use VBA to open some regular macro, you know with 'Application.Goto Reference:="the name of the Sub"'. This doesn't work if the Sub is in the UserForm. How should I name the Reference? Any ideas?

Mudface · Mar 19th, 2002, 01:18 PM

Just use UserForm1.Show. You can refer to the controls on the userform, from outside it's module, by prefacing the control name with the userform name eg: -

UserForm1.TextBox1.Text = ""

Sbirro Cornuto · Mar 19th, 2002, 01:37 PM

Quote:

On 2002-03-19 12:18, Mudface wrote:
Just use UserForm1.Show. You can refer to the controls on the userform, from outside it's module, by prefacing the control name with the userform name eg: -

UserForm1.TextBox1.Text = ""

How would I exactly use UserForm.Show? I don't want to show the UserForm, I want to open the UserForm code window in VBE by VBA. Understand? To open the Sub something() in the editor by macro and the Sub something is on the UserForm.

Sbirro Cornuto · Mar 19th, 2002, 02:02 PM

Anyone? Please! Mudface? Cum on man, let me have it...

Sbirro Cornuto · Mar 19th, 2002, 02:17 PM

Is this really this hard? Cum on guys! Be a punch of pals and give it to me!

Sbirro Cornuto · Mar 20th, 2002, 02:14 AM

Any of you new guys got an idea?

Andrew XJ · Mar 20th, 2002, 02:24 AM

UserForm1.Show has already been the exact VBA code to show a userform.
You can try.

Tom Schreiner · Mar 20th, 2002, 02:44 AM

Tom Schreiner · Mar 20th, 2002, 02:46 AM

A form is a class module...

The answer given seems to be right

Use this syntax

frmYourForm.Sub_Name

This will load the form into memory but will
not show it

Tom Schreiner · Mar 20th, 2002, 02:51 AM

Just to clarify dude.
You have a form called frmDude
Contained within the forms code you have a sub called...
Sub RunThisSub
'code
End Sub

To access this sub outside of the actual running form use this syntax

frmDude.RunThisSub

As I said before, this will load the form into memory but will not show it.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 01:04 PM	#1
Sbirro Cornuto Board Regular Join Date: Mar 2002 Location: Little Italy Posts: 93	'Sup? How can I open the UserForm code module by macro. Like when I use VBA to open some regular macro, you know with 'Application.Goto Reference:="the name of the Sub"'. This doesn't work if the Sub is in the UserForm. How should I name the Reference? Any ideas?

Mar 19th, 2002, 01:18 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Just use UserForm1.Show. You can refer to the controls on the userform, from outside it's module, by prefacing the control name with the userform name eg: - UserForm1.TextBox1.Text = ""

Mar 19th, 2002, 02:02 PM	#4
Sbirro Cornuto Board Regular Join Date: Mar 2002 Location: Little Italy Posts: 93	Anyone? Please! Mudface? Cum on man, let me have it...

Mar 19th, 2002, 02:17 PM	#5
Sbirro Cornuto Board Regular Join Date: Mar 2002 Location: Little Italy Posts: 93	Is this really this hard? Cum on guys! Be a punch of pals and give it to me!

Mar 20th, 2002, 02:14 AM	#6
Sbirro Cornuto Board Regular Join Date: Mar 2002 Location: Little Italy Posts: 93	Any of you new guys got an idea?

Mar 20th, 2002, 02:24 AM	#7
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	UserForm1.Show has already been the exact VBA code to show a userform. You can try.

Mar 20th, 2002, 02:44 AM	#8
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824

Mar 20th, 2002, 02:46 AM	#9
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	A form is a class module... The answer given seems to be right Use this syntax frmYourForm.Sub_Name This will load the form into memory but will not show it

Mar 20th, 2002, 02:51 AM	#10
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Just to clarify dude. You have a form called frmDude Contained within the forms code you have a sub called... Sub RunThisSub 'code End Sub To access this sub outside of the actual running form use this syntax frmDude.RunThisSub As I said before, this will load the form into memory but will not show it.