I want to disable/enable a checkbox in an excel sheet using vba based on the value/conditon of another checkbox. I cannot use the checkbox name, I want to use it's cell location in reference to the cell location of the checkbox that is enabling/disabling it. something like this:
ActiveSheet.Shapes(<>).ControlFormat.Enabled = 0
Aucun commentaire:
Enregistrer un commentaire