+ Reply to Thread
Results 1 to 8 of 8

Code not working to pop up userform??

  1. #1
    Registered User
    Join Date
    07-06-2015
    Location
    Phoenix , AZ
    MS-Off Ver
    2010
    Posts
    47

    Code not working to pop up userform??

    Hello everybody this is my second attempt in building a user form in excel and I want the form to pop up automatically when excel is open and macros is enable which I have done before and I used the code below but for some reasons its not working on this user form ?? Any help please



    Please Login or Register  to view this content.


  2. #2
    Valued Forum Contributor Gatti's Avatar
    Join Date
    06-08-2015
    Location
    Brasil, São Paulo, Ribeirão Preto
    MS-Off Ver
    365
    Posts
    346

    Re: Code not working to pop up userform??

    Hello my friend

    Let's name your Userform as MyForm, okay?

    Put this code into Workbook VBA Page:

    Please Login or Register  to view this content.
    If I have solved your question, please mark the thread as [SOLVED],
    And consider adding reputation

    ?Simplicity is the ultimate sophistication? (Leonardo Da Vinci)

    Regards,
    F?bio Gatti

    https://www.youtube.com/pulodogatti
    https://www.linkedin.com/in/fabiocgatti/
    https://instagram.com/pulodogatti

  3. #3
    Registered User
    Join Date
    07-06-2015
    Location
    Phoenix , AZ
    MS-Off Ver
    2010
    Posts
    47

    Re: Code not working to pop up userform??

    I tried that code as well but nothing working ??

  4. #4
    Valued Forum Contributor Gatti's Avatar
    Join Date
    06-08-2015
    Location
    Brasil, São Paulo, Ribeirão Preto
    MS-Off Ver
    365
    Posts
    346

    Re: Code not working to pop up userform??

    Did you put the code inside WORKBOOK VBA Page?

    It should run the macro everytime workbook opens, and the macro is MyFormName.show

    If doesn't work, could you please post the workbook here or a sample?

  5. #5
    Registered User
    Join Date
    07-06-2015
    Location
    Phoenix , AZ
    MS-Off Ver
    2010
    Posts
    47

    Re: Code not working to pop up userform??

    I tried both codes but still not working here is the workbook.. again I am new at this its my second time Patient Wellness Form.xlsm

  6. #6
    Valued Forum Contributor Gatti's Avatar
    Join Date
    06-08-2015
    Location
    Brasil, São Paulo, Ribeirão Preto
    MS-Off Ver
    365
    Posts
    346

    Re: Code not working to pop up userform??

    Tried the way I said and worked fine:

    Capturar.JPG

    Check on it

    Patient Wellness Form.xlsm

  7. #7
    Registered User
    Join Date
    07-06-2015
    Location
    Phoenix , AZ
    MS-Off Ver
    2010
    Posts
    47

    Re: Code not working to pop up userform??

    I was putting the code in the wrong place haha it works now! Thank you so much!

  8. #8
    Valued Forum Contributor Gatti's Avatar
    Join Date
    06-08-2015
    Location
    Brasil, São Paulo, Ribeirão Preto
    MS-Off Ver
    365
    Posts
    346

    Re: Code not working to pop up userform??

    Glad to help

+ 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 backcolor code not working
    By saziz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-04-2015, 06:39 PM
  2. [SOLVED] userform search code not working
    By vickyp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2013, 02:33 PM
  3. [SOLVED] getting data from command button in userform why is my code not working?
    By Curious2 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-07-2013, 10:37 AM
  4. [SOLVED] Excel vba userform - code for command button not working
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2013, 11:27 AM
  5. Code to write data from userform to worksheet not working
    By Lothar69 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2011, 03:28 PM
  6. Windows Encryption Code not working with Userform
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2006, 06:30 PM
  7. [SOLVED] Code not working when transfered into Userform
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-28-2005, 06:06 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