Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check a checkbox in a formula | Excel Worksheet Functions | |||
Error in code to Check Forms Checkbox | Excel Programming | |||
Checkbox value X instead of check | Excel Programming | |||
Button Enabling based on check in checkbox | Excel Programming | |||
Can't check ActiveX checkbox on worksheet | Excel Programming |