activex controls excel 2007 - Weird!
Patrick,
Thanks for the feedback.
I try to avoid using ActiveX controls but sometimes you just need that
extra bit of flexibility and in this case thats just what l need!
It seems to me from the research l have done over the past few hours
that it is quite well known in the 'developer' community that these
controls are 'flakey' when used on the sheet itself but more reliable
when used on a userform, which in this case is not an option.
In my opinion Microsoft are not doing themselves any favours making
ActiveX forms available for sheet use when it is evidently known to be
unreliable, surely a product as widely used as Excel should not have
inherent 'bugs' over several releases / generations - perhaps that is
why there is so little information on the Microsoft web site about
this subject!
Regards
Michael
|