Solution (or you can say avoiding the problem):
I might have learned the hard way but maybe thats how it works.
unlinked the cells from the controls and re-linked them through th
code for the control (i.e. on_Click or on_Change). This way it does no
give any error. Only when the control has a cell linked directly throug
its properties, it gives the problem. But without changing anything a
all, I just unlinked it and wrote it down in its code and it work
perfectly fine.
Any comments on this. Anyway thanks for all the help.
Manges
--
Message posted from
http://www.ExcelForum.com