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

Popular posts from this blog

Command prompt result in label. Python 2.7 -

javascript - How do I use URL parameters to change link href on page? -

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -