mercredi 10 janvier 2018

Adding Multiple checkboxes in a single cell in Excel and then linking them to another spreadsheet

I am relatively new to Excel VBA. I am trying to do the following

I want to add multiple checkboxes (call, email, text, meet) in a single cell next to a person's name. I want to then link the result of these check boxes in another spreadsheet. Lets call this spreadsheet "Results".

So in theory, if there was a person named Mike and I clicked on the Call and Email checkboxes next to his name, I would want the "Results" spreadsheet to show "True" for Call and Email and "False" for the other two options.

Can someone help me with the VBA macro script to add these checkboxes and link the results for these checkboxes in another cell?

Thank you so much for your help in advance




Aucun commentaire:

Enregistrer un commentaire