Viewing a UserForm

  • Thread starter Thread starter JMay
  • Start date Start date
J

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>>>
 
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
 
Much obliged...Chip
JMay

Chip Pearson said:
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
Click to expand...
 
Back
Top