Esc out of userforms
 

Dear All

How do I ESC out of a userform, no button clicks etc allowed!?

Any help as always from you guys greatly appreciated.

Mark (InWales)

Esc out of userforms
 

Create a commandbutton, set the Cancel property of that button to True, and
havge some click code on that button that unloads the form.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mark (InWales)" wrote in message
...
Dear All

How do I ESC out of a userform, no button clicks etc allowed!?

Any help as always from you guys greatly appreciated.

Mark (InWales)

Esc out of userforms
 

That's great Bob once again thank you very much for help.

Mark (InWales)

"Bob Phillips" wrote in message
...
Create a commandbutton, set the Cancel property of that button to True,
and
havge some click code on that button that unloads the form.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mark (InWales)" wrote in message
...
Dear All

How do I ESC out of a userform, no button clicks etc allowed!?

Any help as always from you guys greatly appreciated.

Mark (InWales)