Can you please write me a micro code that will help me to do so. I am not
expert on using macros.

"Joel" wrote:

If you go into design mode and double click the check box it will create a
click macro. Put macro code into the click code to make the cells appear or
disappear.

"pmss" wrote:

Thanks
Actually i need to have some cells appear when i checked the box so that i
can put my values in the appeared cell.

"pmss" wrote:

i am doing some calculations using Macros. I have problem with check boxes. I
want to link with some cells so that i can put my input parameters there for
futher calculation. when i checked the box, link cells must appear and
viceversa.
Thanks