Form in VB Editor

[Allen]

This is my first attempt using VB Editor to do somthing
that would seem to be easy...but I'm not getting it.

I developed a form in the editor. The form when I run it
does everying I want it to do while I am in the editor.

When I close out of editor how do I access the form? I
tried making a button to push but it's only allowing me to
assign a macro to it. These macro's are located in the
Module. The form is not.

Help Thanks.

 

[Chip Pearson]

Allen,

You need to create a macro to show the form, and assign that
macro to a command button or menu item. E.g.,

Sub ShowTheForm()
UserForm1.Show
End Sub


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