You did not post your code but perhaps using
application.volatile
as the first line might help

--
Don Guillett
SalesAid Software

"Hotbird" wrote in message
...
I have written a Function which delivers a status report to spreadsheet
cell
C5. This is the formula in cell C5:
=FQSUM(B2,A1,Historical!C1,Historical!G1). The only problem is that the
status report does not dynamically update as the parameters are adjusted
by
a Spin Button located on Form StartQN. This is called by: "StartQN.Show"
and dismissed by: "Unload StartQN". The Function string does update
after
the Form is unloaded, but not whilst the Form is active, thereby reducing
its usefulness. What I need is a line of code within the Private Sub
SpinButton1_SpinUp() (and down) procedures to force the Function to
recalculate for cell C5. Any suggestions?