Don,

J-Walk has some coding on his site to create a class module
to handle groups of controls.

You said that you're changing cells on worksheets. Are they
linked cells? Is there anything that's firing the sheet or
workbook calculate event? You might be able to use that.

IMHO though, I think it's overkill to try to detect changes on the
UserForm just so the user won't see you cancel message if they
try to close the UserForm with the "X". You have a button that
closes the form and performs whatever tasks you want it to.
They should learn to use it and they won't get your warning message.

Another option you might want to try is to create a userform
without the "X". You can find an example at Steven Bullen's
site (FormFun.zip)
http://www.bmsltd.co.uk/Excel/Default.htm

John



"Don Wiss" wrote in message
...
On Mon, 1 Dec 2003, John Wilson wrote:

One thing that you could do is set a public variable in the
UserForm and set it to true when a change event on any
of your controls is fired.

Uh, thanks, but this is a six tab input form with over 100 text fields,
option buttons, checkboxes, comboboxes, etc. No way am I going to create
change events for all of them.

Each also corresponds to a cell someplace on the spreadsheet. I could
compare each field to see if still the same, but again great overkill for
the problem at hand.

Don <donwiss at panix.com.