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.