jeudi 5 mars 2015

enable/disable checkbox by its resident cell location

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