Disable X on user form REF: thread707-746401

[cjjn]

Hello,

I have read this and i have just one silly question...

Where do I put the code that gives the Message Box?

Thanks in advance

 

[PHV]

In the UserForm_QueryClose event procedure, as clearly stated in the referenced thread.

 

[cjjn]

Oh man
Ever have one of those days where you feel dumb as a post?!

Thank you PHV.

Now what happens if I want the form to close once data has been entered and they click my OK button?

I have 'Unload Me' in there - but it still doesnt close the form.

Thanks again.

 

[PHV]

Perhaps something like this ?
Unload NameOfUserForm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cjjn]

No, I had tried both ways before posting.

 

[rmikesmith]

cijn,

Can you post your QueryClose event and OK button Click event code. That might help. The code in thread707-746401 + a CommandButton firing Unload Me works fine for me.


Regards,
Mike