Consulting

Results 1 to 2 of 2

Thread: Userform_activate from immediate window?

  1. #1
    VBAX Tutor
    Joined
    Mar 2010
    Posts
    287
    Location

    Question Userform_activate from immediate window?

    I am doing a few changes and would like to be able to launch the userform.

    For subs I would normaly type Application.Run(xyz) but I am not sure how to launch a userform?

  2. #2
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    I would normaly have a sub[vba]Sub showUF()
    Userform1.Show
    End Sub[/vba]so that I could step through the initialize event. But entering Userform1.Show in the immediate window will bring up the UF.

Posting Permissions

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