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

javascript - Knockout pushing observable and computed data to an observable array -

'hasOwnProperty' in javascript -

sitecore - Resolve ISitecoreService using SimpleInjector -