couple userform questions
Gary
The problem is that when the x is clicked, the form is unloaded, so there is
nothing to test against. Therefore you have to trap the close event, which
is what Query Close gives you.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
harald:
i did try it. i know you know a lot more than i'll ever know. what i was
looking
for was a simple, built in way. i thought there may be a method i didn't
know
about. why isn't there a built in option, just like show, hide, activate?
every
userform has an x,
figured if the x was clicked, the userform was closed and it could be
acted on
without writing code
to do it.
--
Gary
"Harald Staff" wrote in message
...
Bob explained the theory. I told you to try it and I guess you didn't.
Many
people refuse to try a solution they don't immediately understand. That
is
not a good approach. Most solutions to anything are complicated and
illogical, but they work anyway.
Best wishes Harald
"Harald Staff" skrev i melding
...
Hi Gary
Try the X on userform1.
|