2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Excel Check boxes with more than just True/False responses

I was chatting with Gemini and it seemed to this this was possible with a script, but I could only find way to create checkboxes online...

Currently a checkbox is either checked (TRUE) or unchecked (FALSE), and clicking the box toggles between those two options, is it possible to change these two options and create a third or fourth option?

My specific use case is a project tracker, but instead of just using the checkboxes for complete or incomplete; I would like it to toggle between 1) In progress, 2) Complete with exceptions and 3) Complete without exceptions. Basically I want a bit more tailored information out of that check box, but since a lot of people use this Status Sheet I want to keep the check box logic (otherwise someone will inevitably unknowingly copy & paste data and overwrite other projects' status while rows are filtered or hidden).

For some background my team does about 500 projects and each has about 5-10 sections, so I want a nice way of tracking each project and the sections. (People have a tendency to not tell you there are exceptions lurking in the files, so I need a good way for forcing that issue to our Status Sheet).

submitted by /u/East_Direction9563
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#rows.com
#Excel compatibility
#Excel alternatives
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel
#checkbox
#project tracker
#True/False