Hi richard,

I had a togh weekend, so no excel for me...
Now it's a new mondya and we start again...
Your idea works fine if you terminate the userform, but i don't terminate the
userform. The application is run entirely through the userform. The worksheet
(1) should be recalculated when a change is made on one of the multipage
userform !

I would be much obliged if you have some more suggestions...
Thanks,
Jean-Pierre

Richard Buttrey wrote:
Hi richard,

[quoted text clipped - 13 lines]
Thanks,
JP

I've tried to mimic what I think you mean. I have a Sheet1 in which A1
is the cell linked via the ControlSource property to the Textbox.

I have the Userform showing on Sheet2 and with the code modified as
below to include a reference to Sheet1

Private Sub UserForm_Terminate()
If Worksheets("Sheet1").Range("a1") 1 Then
Worksheets("Sheet1").Range("a1") = Worksheets("Sheet1").Range("a1") /
100
End Sub

This works for me, and changes A1 and all dependent cells on Sheet1 as
I'd expect.

Am I missing something....???

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200508/1