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)

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)

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)