Scottie P
03-22-2005, 11:11 PM
ok...this has to be something obvious since I haven't been able to figure it out. I ask this question with the knowledge that I will be kicking myself as soon as I see the answer.
What I would like to do is have an event fired when a userform is closed (via the Red X on the Title Bar of the userform). Is this easy enough? I have never attempted to run a process in this manner, so I have no idea if this is even a 'legal' measure. My initial instinct is to set it up like:
'
'This is not good code! Do not attempt this at home!
'
Private Sub Userform_whatgoeshere?() '<-need this part and...
The userforms now closing so... '<-... I need this part as well
DoEvent '<-placed here to indicate that this is where we pick up again (will not actually be used)
Selection.GoTo What:=wdGoToBookmark, Name:="bkmk1"
End Sub
'
I have spent some time reading through the Newsgroups tonight, but haven't hit anything quite like this. There is other code in the document but certainly nothing that would interfere or be interfered with. Just need this last piece of my sorted and twisted puzzle...:bug:
Them be the basics. What fundamental piece did I grossly overlook? :rotlaugh:
No hurry on this and thank you for taking the time!
Scott
What I would like to do is have an event fired when a userform is closed (via the Red X on the Title Bar of the userform). Is this easy enough? I have never attempted to run a process in this manner, so I have no idea if this is even a 'legal' measure. My initial instinct is to set it up like:
'
'This is not good code! Do not attempt this at home!
'
Private Sub Userform_whatgoeshere?() '<-need this part and...
The userforms now closing so... '<-... I need this part as well
DoEvent '<-placed here to indicate that this is where we pick up again (will not actually be used)
Selection.GoTo What:=wdGoToBookmark, Name:="bkmk1"
End Sub
'
I have spent some time reading through the Newsgroups tonight, but haven't hit anything quite like this. There is other code in the document but certainly nothing that would interfere or be interfered with. Just need this last piece of my sorted and twisted puzzle...:bug:
Them be the basics. What fundamental piece did I grossly overlook? :rotlaugh:
No hurry on this and thank you for taking the time!
Scott