I have a textbox on a worksheet and a macro is attached to the textbox when
there is a change. However, the textbox1_update event is called when the
first keystroke is hit. So if I want to enter 45, it only recognizes 4 and
not 45. Am I calling the right event? I just want to be able to enter a
number in the textbox and once it's done, it will run a procedure.

Thanks

Change it from the Textbox1_Change vent to:
Textbox1_Exit event.

It will not update until the textbox has been left.

Corey....

"matelot" wrote in message
...
I have a textbox on a worksheet and a macro is attached to the textbox when
there is a change. However, the textbox1_update event is called when the
first keystroke is hit. So if I want to enter 45, it only recognizes 4 and
not 45. Am I calling the right event? I just want to be able to enter a
number in the textbox and once it's done, it will run a procedure.

Thanks

Try the Exit event.


"matelot" wrote in message
...
I have a textbox on a worksheet and a macro is attached to the textbox when
there is a change. However, the textbox1_update event is called when the
first keystroke is hit. So if I want to enter 45, it only recognizes 4 and
not 45. Am I calling the right event? I just want to be able to enter a
number in the textbox and once it's done, it will run a procedure.

Thanks