lifeson
04-04-2007, 03:49 AM
Is there any code to prevent sub routines running?
I have a user form that displays records and it that uses various controls with code activating on change events.
I also have a button which resets the form to allow a new entry to be added, but I want to disable the on chnage routines.
Is this possible?
ie
On cmdButton click ignore Private Sub cboType_Change()
TIA
I have a user form that displays records and it that uses various controls with code activating on change events.
I also have a button which resets the form to allow a new entry to be added, but I want to disable the on chnage routines.
Is this possible?
ie
On cmdButton click ignore Private Sub cboType_Change()
TIA