Question
February 11, 2009 at 12:05 PM
chrisd

Setting the Visible Property of a ComboBox based on the value of a CheckBox

by chrisd . Updated 17 years, 7 months ago

I’m having a heck of a time with this. Basically, I’m creating a calculator that calculates the value of a building. I need to set the Visible property of a combo box to be true if a checkbox is not selected, and false if it is selected.

Currently, I’ve created a macro for the checkbox that runs when the checkbox is clicked. This is the macro, but it appears to do nothing.

Sub CheckBox3_Click()
If Checkbox3 = False Then
Sheet1.cmbGarage.Visible = True
Else
Sheet1.cmbGarage.Visible = False
End If
End Sub

The cmbGarage control was created off the Controls Toolbox, while the CheckBox3 checkbox was created using the Forms toolbox.

Thank you.

This discussion is locked

All Comments