How to Check a checkbox on spreadsheet from VB code
 

Please give some input on how to check/uncheck the checkbox which is placed o
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

Thank
Harinath

How to Check a checkbox on spreadsheet from VB code
 

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

How to Check a checkbox on spreadsheet from VB code
 

Hi bob

thanks a lot ..what you have sent is working out..

Once agai
Thank
Harinath