Worksheet not updating when execute mytxt.value line in VBA
 

I have a userform with textboxes linked to worksheet ranges via the
control source property
When the AfterUpdate event fires on a textbox it calls a validation
routine which resets the textboxes value to 0 if the user has entered
non numeric data.

...
..
MyTextbox.Value = 0



While the textbox on the userfom now shows 0 the corresponding cell in
the worksheet is still displaying the user entered non numeic data
instead of the 0

Why is the control source not pushing the new value 0 thru to the
worksheet

Many Thanks

Tony Miller