Viewing a UserForm

[JMay]

I've created a user form in my VBE Window. When I click "Run" it switches
to my spreadsheet and appears. When I click on the "x" upper right in the
spreadsheet I'm switched back to my VBE window.
I want to switch to my blank spreadsheet and click on something for the form
to come up,, but I'm not finding what to click-on, or do.. I hope this
isn't to obvious, <<<VBG>>>

 

[Chip Pearson]

If you start the form from within VBE, then you'll return to VBE. You can
create a macro to show the form, e.g.,

Sub ShowTheForm()
UserForm1.Show
End Sub

and execute this macro from the Macros dialog, or assign this macro to a
menu item or toolbar button. In these cases, you'll return to Excel, not
VBE, when the form closes.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[JMay]

Much obliged...Chip
JMay

If you start the form from within VBE, then you'll return to VBE. You can
create a macro to show the form, e.g.,

Sub ShowTheForm()
UserForm1.Show
End Sub

and execute this macro from the Macros dialog, or assign this macro to a
menu item or toolbar button. In these cases, you'll return to Excel, not
VBE, when the form closes.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com