Results 1 to 7 of 7

Thread: UserForm Running - While Jumping to Application GoTo Statement - Unload

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Mentor
    Joined
    Feb 2016
    Location
    I have lived in many places, I love to Travel
    Posts
    413
    Location

    UserForm Running - While Jumping to Application GoTo Statement - Unload

    folks,

    good evening,

    I thought i would work a bit on my userform its been stuck for a while.

    I cant figure out what the problem is.

    I used application go to to go to the location of the macro

    But the userform is still running and wont let me edit in the module.

    I just want to go to the module - Yes it does that , but the userform is still running so i cant do anything - unless i close the userform

    if i close the userform i lose my location that i jumped to

    Private Sub CommandButton1_Click()
    
    
    'Go to the macro place in the module macros
      
        With Application
            .Goto ListBox1.Column(1)
        End With
        Unload Me     ' <<<  this wont let me go to the module
      
    End Sub
    what can i use to stop the userform running while i jump to the module

    its not very clear what i mean but you can see form the userform

    I have attached the offending culprit here

    thank you for your advice
    Attached Files Attached Files
    Cheers for your help

    dj

    'Extreme VBA Newbie in progress - one step at a time - like a tortoise's pace'


Posting Permissions

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