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

'hasOwnProperty' in javascript -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

java - How to provide dependency injections in Eclipse RCP 3.x? -