excel - Activating the ComboBox when the CheckBox is checked -
i trying make userform if checkbox marked combobox allowed clicked. here code:
private sub combobox3_change() if checkbox1.value = true combobox3.enabled = false end if end sub
it doesn`t work , have no idea why.
from narrative
if checkbox marked
i'd assume want react checkbox status change, need checkbox event handler
private sub checkbox1_click() combobox3.enabled = checkbox1.value end sub
Comments
Post a Comment