Apple like Switcher in Excel

**brisardo** · 07-17-2017, 09:55 AM

Hello,

I would like to know if you have an idea about how to create a switch button like Apple or Android are having in their settings?

If left A1=1 if right A1=0?

https://developer.apple.com/ios/huma...rols/switches/

aca6b271a428b3a36997bbb1204c0d52.jpg

Thank you very much,
Bris

**Syrkrasi** · 07-17-2017, 02:52 PM

The easiest way that I can think of is using scrollbars or Spin buttons with helper fields and Conditional formatting.

see attachment

Re: Apple like Switcher in Excel