SSW
05-06-2015, 01:34 PM
Hi All,
I am new to VBA and hope somebody here will be able to help me.
I have a form with just one text box. I have a code which should trigger once the textbox value is changed.
Currently, once I enter a value and press enter, it doesnt trigger the event.
The event is triggered only when I close the form.
I read that the event is triggered only when the focus is changed from the text box. Does that mean I need to have more than 1 text box?
Why doesn't pressing 'Enter' key trigger the event?
Thanks!!
I am new to VBA and hope somebody here will be able to help me.
I have a form with just one text box. I have a code which should trigger once the textbox value is changed.
Currently, once I enter a value and press enter, it doesnt trigger the event.
The event is triggered only when I close the form.
I read that the event is triggered only when the focus is changed from the text box. Does that mean I need to have more than 1 text box?
Why doesn't pressing 'Enter' key trigger the event?
Thanks!!