textchanged event trigger with enter key

[mygirl22]

hi,
How do i code an enter event textchanged event to only work when the enter key is pressed?

1. i have a text button that has a value, or a user can enter their own value
2. however when they enter their own value, the total value doesn't changed because they need to press the enter key to validate the event....am stuck, plz help

[smartchap]

Dear mygirl22
In place of change event in KeyPress event of the text box u use
If KeyAscii = vbKeyReturn Then .....
so that on pressing Enter key code after THEN will get executed.

[debasisdas]

you need to code that in keyPress event .

[mygirl22]

thank

Dear mygirl22
In place of change event in KeyPress event of the text box u use
If KeyAscii = vbKeyReturn Then .....
so that on pressing Enter key code after THEN will get executed.

thanks i figured it out