optionbutton - how to enable / disable option button in excel -

i have problem resolving 1 issue in excel, hope if can help

i have 3 option buttons in excel want these option buttons enable if corresponding cells (d1 option button1, d2 option button 2 , d3 option button 3) has values, if empty corresponding option button disable, can me please

thanks

you can try this:

activesheet.shapes("commandbutton1").select if cells(1, 4).value <> cells(1, 1).value     selection.enabled = true else     selection.enabled = false code here end if 

here compare value of d1 cell value of a1 cell. hope helps you!!!