Hi Michelle,

On my user form, I want Control1 to effect the value of Control2, but when
it does, I don't want the change event for Control2 to be triggered.

Enable events doesn't work

Can I temporarily switch off the change event, then change the control then
switch it back on?

See:

http://www.jkp-ads.com/Articles/NoEvents00.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com