Consulting

Results 1 to 3 of 3

Thread: Solved: Multiple versions of UserForm

  1. #1
    VBAX Regular
    Joined
    Jun 2006
    Posts
    20
    Location

    Question Solved: Multiple versions of UserForm

    Is it possible to open multiple copies of the same userform? If so how !

  2. #2
    VBAX Master Killian's Avatar
    Joined
    Nov 2004
    Location
    London
    Posts
    1,132
    Location
    Hi and welcome to VBAX

    A userform is a class (with a GUI) so it can be instanced in the same way.[VBA]'assuming you have created a form called "UserForm1"
    Dim f As UserForm1

    Set f = New UserForm1
    f.Show[/VBA]For multiple instances, you will, of course, have to account for the "modal" behaviour of forms.
    K :-)

  3. #3
    VBAX Regular
    Joined
    Jun 2006
    Posts
    20
    Location

    Thank you!

    Works a treat, thank you!

Posting Permissions

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