Reference a checkbox control (Excel2000)

Topic

New Reply

I have a worksheet with several checkboxes.
How do I reference them in VBA to hide them or make them visible when the user clicks on certain items.

Thanks,
Scott

Reply | Quote

Replies

Did you create the check boxes from the Forms toolbar or from the Control Toolbox?

Reply | Quote

Hans,
I created them from the Forms tooolbar.

Reply | Quote

Select a check box by right-clicking it.
Switch to the Visual Basic Editor (Alt+F11).
Activate the Immediate window (Ctrl+G).
Type ? Selection.Name and press Enter.
You’ll see the name of the check box, you’ll need this.

To control the visibility of a check box named “Check Box 1”:

ActiveSheet.Shapes(“Check Box 1”).Visible = False

(or True, of course).

To change its value:

ActiveSheet.Shapes(“Check Box 1”).ControlFormat.Value = xlOn

(or xlOff, of course)

Reply | Quote

Thanks,
I will play around with the controls.

Scott

Reply | Quote