lundi 13 juillet 2020

How to change Default True/False values in Form Control checkbox to different value in another tab

I am having two sheets in a excel, sheet1, sheet2. I configured form control checkbox in sheet2 which will trigger True/False in sheet1 cell D6. Now i am trying to put a value in sheet1 cell D6 instead of True/False whenever i click checkbox in sheet2. How to achieve it. It worked for ActiveX checkbox but i am looking for form control checkbox. Thanks in advance




Aucun commentaire:

Enregistrer un commentaire