How to create a toggle button in Excel

Trying something new. This video is created using Google Text-To-Speech service. Let me know what do you guys think.

A toggle button is a control to set a value to either True/False. By incorporate a toggle in our Excel application, we can present our Excel application as more polished and professional.

Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
🔑 Venmo: @Jie-Jenn

Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#Excel #ExcelTip #ToggleButton

[platinumtoast]

Sounds great. What voice did you use for the video?

[holahulu-cw]

Thank you for sharing, i got it to work on a proce sheet for my job so I could compress pre and post tax prcing easier. After all that i relaised macros werent available through onedrive :( ah well, at least it works on my local copy i could at least copy the values over to the onedrive copy

[petermanesh]

Fantastisk funktion.
Er der en mulighed for at du sender den eller jeg kan doawnload det?
På forhånd tak

[merinrenjith]

Hi great video. Could you please help me with the code to add this toggle button to another 6 worksheets as well?

[mlzorb]

Great video. I was able to successfully re-create this feature. I want to use the toggle button to allow my users to auto-fill Check Boxes for recommended subset of testing from a full list of testing available. However, when I protect the worksheet, the toggle no longer works (Run-time error '1004': Unable to set the Text property of the Characters class) ...I verified that the ToggleValue cell that sets the TRUE/FALSE conditions is unlocked. I also tried right-clicking on the toggle button and unlocked text under the Format Shape properties but that didn't work, either.

How can I protect the worksheet so that users don't inadvertently make changes to my form but still have the toggle functionality?

[MrPantburg]

Great video. I have a list of items, one item per line. I would like to create a copy of these buttons with one on each line. Is there an easy to this? I am assuming we would need some form of relative reference, rather than defining the name of the result cell as "ToggleValue".

[SpeedohDark]

What would cause my toggle button to increase in size with ever mouse click? It’s a small increase, but over time it adds up.

[kaironbeau]

Followed all your instruction and yet encountered "run time error 424, object required". When debug, erro came from Set ws = ThisWorkbook_Activesheet, it says that ThisWorkbook_Activesheet = empty. How to fix this error?

[QNag]

Run-time error '1004': Method 'Range' of object '_Worksheet' then highlights this line: If .Range("ToggleValue").Value = True Then

[paaskanama]

Tone is realistic. Delivery is noticeably robotic.