Hello all, easy problem I hope!

Please Login or Register  to view this content.
R1 is from a formula, R3 is data I enter.

When I change R3 by typing in a value, the macro works.

When R3 gets changed by a scroll bar (form controls), it does not work, and gives me a "Application defined or object defined error 50290"..

It is as if Excel has to 'exit' from this form control thing and go back to its usual duties.. Does anyone have a sollution to this?

Regards,
Niels