The afterupdate is "inherited" from the controls object. So no, the textbox
itself does not have the AfterUpdate event. If you put the same textbox
control on a worksheet, you will see there is no AfterUpdate event as an
illustration. Another example of "inheritance". On a userform, the
combobox has a rowsource, but on a worksheet it is ListFillRange. This is
because these properties belong to the control and oleobject objects
respectively.

--
Regards,
Tom Ogilvy

"phreud " wrote in message
...
You're right. I tried to adapt John's method to make it work in my case,
but couldn't.

However, surely a TextBox has an AfterUpdate event? The code I'm using
now is:


Code:
--------------------

Private Sub txtSomeName1_AfterUpdate()
Update_Chart
End Sub

Private Sub txtSomeName2_AfterUpdate()
Update_Chart
End Sub

Private Sub txtSomeName3_AfterUpdate()
Update_Chart
End Sub

Private Sub txtSomeName4_AfterUpdate()
Update_Chart
End Sub

--------------------


and so on....

This was the reason for my post. It seems there should be a way to get
around this. I have about 50 text boxes that need to be called like
this :(


---
Message posted from http://www.ExcelForum.com/