+ Reply to Thread
Results 1 to 3 of 3

Programatically cretae and initialize a userform

  1. #1
    Registered User
    Join Date
    06-03-2017
    Location
    portugal
    MS-Off Ver
    2016
    Posts
    1

    Cool Programatically cretae and initialize a userform

    Hello Everybody

    I'm trying to create and initialize an userform dynamically. I can create it but not initialize. I'm publishing the code that I'm using
    the problem occurs when in Userform_Initialize it doesn't recognize the variable FormName

    Some ideas

    Thanks


    Please Login or Register  to view this content.
    Last edited by Glenn Kennedy; 07-08-2021 at 03:21 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Programatically cretae and initialize a userform

    1. I have moved your thread from the "Introduce Yourself" thread to the correct place.

    2. You broke Forum Rule 2 (which you agreed to stick to when you joined) and did not put your code inside code tags. I have done it for you ON THIS occasion.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,158

    Re: Programatically cretae and initialize a userform

    paulonobre, I'm not sure you meant that. The revised code below creates a new UserForm in the project and runs it. But the next macro call will create a new UserForm in the project. On the other hand, you may want to create the UserForm on the fly, but without creating it in a VBA project.
    Please Login or Register  to view this content.
    Artik

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Userform will not initialize
    By opusarlo in forum Excel General
    Replies: 3
    Last Post: 12-13-2016, 04:21 PM
  2. How to use the UserForm Initialize event to Initialize 3 listboxes in the same userform
    By Pimp_mentality in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-16-2016, 02:59 PM
  3. Userform - help with initialize
    By Macster in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-23-2009, 05:40 AM
  4. userform initialize
    By Patrick Simonds in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2006, 06:20 PM
  5. userform initialize
    By Patrick Simonds in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2006, 05:40 PM
  6. userform initialize
    By Patrick Simonds in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2006, 05:35 PM
  7. initialize userform, using a sub
    By natanz in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-22-2005, 01:35 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1