Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005
    Posts
    25

    Unanswered: Can userforms be opened from a macro?

    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??

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •