How to Check a checkbox on spreadsheet from VB code

H

Harinath

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
 
B

Bob Phillips

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)
 
H

harinath

Hi bob

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

Once agai
Thank
Harinath
 
Top