ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Simple Question from Newbie (https://www.excelbanter.com/excel-programming/359758-simple-question-newbie.html)

NoProgram[_3_]

Simple Question from Newbie
 

What's the command line to tick off (or check) a checkbox in the
activesheet?

How do I create a macro that will increment across a row from A1 to B1,
etc...?

Thanks for your help!


--
NoProgram
------------------------------------------------------------------------
NoProgram's Profile: http://www.excelforum.com/member.php...o&userid=33832
View this thread: http://www.excelforum.com/showthread...hreadid=536129


Gert-Jan

Simple Question from Newbie
 
checkbox1.value = 1 'on
checkbox1.value = 0 'off

I don't understand you second question; please explain


"NoProgram" schreef
in bericht ...

What's the command line to tick off (or check) a checkbox in the
activesheet?

How do I create a macro that will increment across a row from A1 to B1,
etc...?

Thanks for your help!


--
NoProgram
------------------------------------------------------------------------
NoProgram's Profile:
http://www.excelforum.com/member.php...o&userid=33832
View this thread: http://www.excelforum.com/showthread...hreadid=536129





All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com