texbox event update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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....

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

referring to texbox 4
Force to update textbox value to cell 1
Firing Event in another user form 1
calling an _Exit event 3
textbox's exit event 1
Writing code to objects within MultiPage object 2
Frame control scroll bar 0
userform exception error 4 textboxes 7

Back
Top