That's a good tip.

I've never used it and now I have a reason! <vbg.

Jan Karel Pieterse wrote:

Hi Dransfield,

I actually only had a few simple controls with ControlSource, as I
suspected, and this excercise has confirmed, that ControlSource is the
work of the devil!

I was going to tell you to avoid the ControlSource. I never use it from within
userforms.
Better to drag your data from the worksheet through VBA and push it back using
VBA too. That also allows you to control when that happens exactly.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

--

Dave Peterson