troubleshooting Question

Enhancement to Check Box Macro

Avatar of Bright01
Bright01Flag for United States of America asked on
Microsoft Excel
8 Comments1 Solution44 ViewsLast Modified:
EE Pros,

I have a great macro that provides me a check mark in a selected box.  How do I add the ability  in the Macro, to move from a check mark, to a  Question mark, to an X?  In other words, when you click on a blank black square, you should get a check mark, then double click again and you get a  ?,  a third time, and you get an X.  Click final  time and it recycles to a blank box.

Attached is the workbook/worksheet.
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros