Hi Harinath,

Try this

ActiveSheet.CheckBoxes("Check Box 45").Value = True


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Harinath" wrote in message
...
Please give some input on how to check/uncheck the checkbox which is
placed on
a spreadsheet using VBA code.

In my case when i right click the checkbox on spreadsheet it is displaying
"Check Box 45" .
can i use this to set the checkbox true or false in code..Is it correct

Thanks
Harinath