On Nov 21, 9:14*pm, GS wrote:
GS did a typo:
First sentence should read...

Protecting the sheet with *'UserInterfaceOnly:=True' *allows code to
work without raising any errors.

Sorry about that!

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Thanks alot for that Gary it's looking good now and I removed the
control source =A4 fromthe textbox pointing to the sum formula cell
which was wiping out the formula altho the text box was locked

I have some forms with scores of text boxes on them and I want to call
an routine when any of the textboxes is updated
So the textboxes pointing to the formula cells get updated
I used to use control source but that wipes out the formula in the
cells

This works but is there a userform event that capture a change to any
textbox or does one need to create a class module
for all textbox afterupdate event?So I dont need to write an event
handler for each textbox

Private Sub TextBox1_AfterUpdate()
TextBox4.Value = Range("A4")
End Sub

Private Sub TextBox2_AfterUpdate()
TextBox4.Value = Range("A4")
End Sub


Private Sub TextBox3_AfterUpdate()
TextBox4.Value = Range("A4")
End Sub