ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   If Checkbox (https://www.excelbanter.com/excel-programming/396980-if-checkbox.html)

Dan Connors

If Checkbox
 
Hello,
I have a checkbox that I would like to have checked if a certain cell is
populated. Any ideas?

Vergel Adriano

If Checkbox
 
If the checkbox came from the Forms Toolbar, something like this:

ActiveSheet.checkboxes("Check Box 1").value=true

if the checkbox came from the Control Toolbar, then like this:

ActiveSheet.CheckBox1.Value=true




--
Hope that helps.

Vergel Adriano


"Dan Connors" wrote:

Hello,
I have a checkbox that I would like to have checked if a certain cell is
populated. Any ideas?



All times are GMT +1. The time now is 07:18 PM.

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