View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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.