Good afternoon all,
Is there a way in a userform where a value has been entered into "textbox1" and then into "textbox2". After which when someone decides to change its mind and once again change value in "textbox1", then "textbox2" should reset/ clear itself of the previous entered value.
eg:
First Manual entry into textbox of numbers:
Textbox1.value = 10
textbox2.value=20
a change in thought occurs and the person changes Textbox1.value = 15.
On this change, the value in textbox2 should automatically reset/clear.
I guess this is a change even procedure (afterupdate), but i am not really familiar with change event procedures.
All help is appreciated.
regards,
Sebastian
Is there a way in a userform where a value has been entered into "textbox1" and then into "textbox2". After which when someone decides to change its mind and once again change value in "textbox1", then "textbox2" should reset/ clear itself of the previous entered value.
eg:
First Manual entry into textbox of numbers:
Textbox1.value = 10
textbox2.value=20
a change in thought occurs and the person changes Textbox1.value = 15.
On this change, the value in textbox2 should automatically reset/clear.
I guess this is a change even procedure (afterupdate), but i am not really familiar with change event procedures.
All help is appreciated.
regards,
Sebastian