hi
I search macro enable me to cancel any events from work on userform when I press button cancel
I have many codes in many events (textboxes,comboboxes ) when I press button(ok ) fill data in sheet , also I have some textboxes link with sheets when run userform it will show in sheet without using button (ok) will show in sheet . I want when I press button( cancel )return data sheet as was before run the userform . this should happens when press button (cancel) .
I no know if what I ask clear or possible does that .
if it's not clear just inform me to provide more details .
I search macro enable me to cancel any events from work on userform when I press button cancel
I have many codes in many events (textboxes,comboboxes ) when I press button(ok ) fill data in sheet , also I have some textboxes link with sheets when run userform it will show in sheet without using button (ok) will show in sheet . I want when I press button( cancel )return data sheet as was before run the userform . this should happens when press button (cancel) .
I no know if what I ask clear or possible does that .
if it's not clear just inform me to provide more details .