on/ff toggle switch

**Kausch** · 03-23-2018, 05:23 AM

Google wasn't very helpful so I'm reaching out to you for help.
I'm looking to create a simple checklist in Excel and want users to toggle ON or OFF using a switch button. No macros needed yet - I simply want to start out with a "toggle" switch and consider writing macros later (if 'on' do something; else do nothing. sort of thing).
ToggleSwitch.png
I know the Control Box has a toggle switch but it appears as a push-in/push-out button. What I need is something more visual. Tick boxes are OK but I prefer the toggle button as shown in the illustration above.
I use Excel 2016 and don't know where such button exist - so I need help how to create one or (preferably) an example Worksheet where I can copy & paste onto several rows.
Any help is appreciated.

**PaulM100** · 03-23-2018, 06:38 AM

Take a look at the example found here:

https://excelchamps.com/blog/create-...tton-in-excel/

**Kausch** · 03-23-2018, 11:37 AM

That was both quick ad very helpful, Paul! thanks

**PaulM100** · 03-23-2018, 11:39 AM

Glad to help. Please mark the thread as Solved if that took care of your problem. Thanks.

**Kausch** · 03-23-2018, 12:28 PM

I had marked as solved, Paul but then I need another associated question: If I want more than one toggle button, I can't seem to work it. See example. Can you help/advise further, please?