Hi Richard,

still struggling....
Yes i tried that but it does not work because the recalculation code is in
the worksheet selection_change() sub....
If i use sheets("sheet1"). it will not execute the code entered in the
worksheet selection_change() part of the code because in sheet1 there is no
selection change at that point.

Any ideas?

Richard Buttrey wrote:
Hi richard,

[quoted text clipped - 4 lines]
(1) should be recalculated when a change is made on one of the multipage
userform !

Have you tried a

worksheets("sheet1").calculate

command somewhere in your coding?

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________


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