dj44
06-10-2017, 06:10 PM
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
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