G Guest Sep 6, 2007 #1 Hello, I have a checkbox that I would like to have checked if a certain cell is populated. Any ideas?
Hello, I have a checkbox that I would like to have checked if a certain cell is populated. Any ideas?
G Guest Sep 6, 2007 #2 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
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