View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
D.S.[_3_] D.S.[_3_] is offline
external usenet poster
 
Posts: 60
Default userform titlebar and closing form

Great, that will work. I found another method, but it's more complicated
that I require for this project.

Thanks,
D.S.


"Chip Pearson" wrote in message
...
DS,

You can use the QueryClose event procedure to catch the form's
closing via the 'X' button.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"D.S." wrote in message
...
I would like to prevent the user from closing a userform by

clicking the 'X'
on the right side of the titlebar. I need to force closure by

using a
command button, and running an exit procedure. Is there a

property setting
that will prevent this / or run the exit procedure when the 'X'

is clicked?

D.S.