+ Reply to Thread
Results 1 to 7 of 7

Issue doubled "userform_initialize" event

  1. #1
    Registered User
    Join Date
    12-19-2016
    Location
    BRAZIL
    MS-Off Ver
    2013
    Posts
    3

    Issue doubled "userform_initialize" event

    Hello,

    I have a userform named "jobmaker" with an event Userform_Initialize, which only makes a label show date.
    In this form I have a button to save my info, and to assure users won't save wrong information I created another form to check that.
    In this other form named "conferir_dados" I put some labels to show the information that shall be checked, and for this I tried to make the labels value change in other "Initialize" event.

    And then the error comes.

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Issue doubled "userform_initialize" event

    hi realbiro,

    Still don't know what the error actually is... but can you maybe post a sample workbook that has this problem so we can see what is happening?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    12-19-2016
    Location
    BRAZIL
    MS-Off Ver
    2013
    Posts
    3

    Re: Issue doubled "userform_initialize" event

    I'm not able to attach a file (don't know why), but, here is an example



    The following is on my userform 2

    Please Login or Register  to view this content.
    And I just realized that the mistake is on the ".Value" at the end of the event.
    What I was trying to do is exactly call the values from a textbox at UserForm1.

    Therefore, the problem is not in the event INITIALIZE of many userforms. My mistake.

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Issue doubled "userform_initialize" event

    Where it says "UserForm1" that needs to be the actual name of the userform that contains the label called Label1. Also, if Label2 is the actual name of the label being updated, just to avoid issues, I'd make the line
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    12-19-2016
    Location
    BRAZIL
    MS-Off Ver
    2013
    Posts
    3

    Re: Issue doubled "userform_initialize" event

    I have checked that many times and it was correct. I gave up and made this in an other way.

  6. #6
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Issue doubled "userform_initialize" event

    I just realized something.... you were talking about labels not textboxes.... Labels don't have a .Value property... it is .Caption.

  7. #7
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Issue doubled "userform_initialize" event

    I should have known that... you were quite clear, I guess I wasn't fully focused yet.

+ 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. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  3. [SOLVED] filling cell in column "a" if data present in column "b" issue.
    By timmatthews in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2013, 11:43 AM
  4. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  5. [SOLVED] Userform - how to close it "before opening it" (in userform_initialize) ?
    By timtim89 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2012, 12:33 AM
  6. ""All Day Event"" Check Box Issues
    By champs in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 04-03-2009, 07:10 AM
  7. [SOLVED] How to have a macro simply issue the "find" command or "control f:
    By Charles Adams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2005, 04:40 PM

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