Thanks Dave for the motivation. With a new zest, I looked into the cod
and found the error. I had named the ComboBox41 as ComboBox1.


Dave Peterson wrote:
*Could it be a problem in xl? Yeah, but I know from my experience
it's usually
my problem--not excel's. I wouldn't give up looking for it.

You have do have macros enabled, right?

Maybe you could create a skinnied down test workbook with just a fe
checkboxes
to see if you can get that working. Once you do, it might be easie
to find the
problem in the original.

Did you go into design mode and double click on the checkbox? An
did you see
your code?



Shilps wrote:[vbcol=seagreen]

Thanks Dave .Actually that is what I want to ask. In my sheet
everything is correct, logically and syntax-wise. Then why is it no
working? Could it be some problem in Excel. It s not easy for me t
create a new sheet as beside this there is lot of oth[/vbcol]
er calculations in this sheet. I created a copy of it, but it didn'
help

--

Dave Peterson



-
shilp
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message573839.htm