+ Reply to Thread
Results 1 to 13 of 13

My Userform don't stop with breakpoints.

  1. #1
    Registered User
    Join Date
    08-06-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    35

    My Userform don't stop with breakpoints.

    Hello,

    I don't know what happened, on my Userform, it doesn't stop in any breakpoint.

    Any help will be helpful.

    FS

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: My Userform don't stop with breakpoints.

    Perhaps it isn't stopping because the code you've put the breakpoints on is never being executed?

    Where have you put the breakpoints?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    08-06-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: My Userform don't stop with breakpoints.

    Hello,

    No, this is not true, for example, I put a breakpoint in the UserForm Initialize and not stop.

    Regards
    FS

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: My Userform don't stop with breakpoints.

    Can you attach the workbook?

  5. #5
    Registered User
    Join Date
    08-06-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: My Userform don't stop with breakpoints.

    Sorry, I do not understand?

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: My Userform don't stop with breakpoints.

    Can you upload an example workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  7. #7
    Registered User
    Join Date
    08-06-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: My Userform don't stop with breakpoints.

    Want me to send the code?

  8. #8
    Registered User
    Join Date
    08-06-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: My Userform don't stop with breakpoints.

    The file was loaded as desired.

    Good luck
    FS
    Attached Files Attached Files

  9. #9
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: My Userform don't stop with breakpoints.

    The initialize event for UserForm1 isn't being executed.

    I don't' know why but there is definitely something strange going on.

    For example UserForm isn't listed in the left dropdown in the UserForm module, it should be.

    UserForm_Initialize is listed but as if it's a separate sub and isn't connected to the userform.

    Also, when you double click UserForm1 focus doesn't goto the Initialize event as it should.

    I did find this strange line in the class module.
    Please Login or Register  to view this content.
    What is that supposed to do?

  10. #10
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: My Userform don't stop with breakpoints.

    I found that if I remove a control from UserForm1 then Initialize is triggered.

  11. #11
    Registered User
    Join Date
    08-06-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: My Userform don't stop with breakpoints.

    Hello,

    Sorry this code belongs to another progam I was doing and did not interfere with the current because it was not called.

    FS

  12. #12
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: My Userform don't stop with breakpoints.

    You mean the file you have uploaded has nothing to do with the problem?
    Last edited by Norie; 05-16-2013 at 04:49 PM.

  13. #13
    Registered User
    Join Date
    08-06-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: My Userform don't stop with breakpoints.

    Yes, yes it is true.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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