Can userforms be opened from a macro?

mike703 · #1 (**permalink**) 07-06-06, 15:35

Hi All,

I have a macro that will format project files based on their project number. in order to record the prject number. I have created a form for the user to enter the project number. My problem is entering a command line to open the form once the user selects which type of project file is to be formatted (a popup window first displays in the macro). I would like for the user form to popup if the correct button is clicked on the original popup window. How??

MikeTheBike · #2 (**permalink**) 07-07-06, 08:06

Hi

I may be being incredibly slow/thick or whatever, but how about

Code:

Private Sub CommandButton1_Click()
    UserForm1.Show
End Sub

!!??

At least this should start the debate on what your real question is !!

MTB

Internet Services

Web Development

Digital Marketing

Consumer Tech