How to create a toggle button in Excel

Рет қаралды 62,869

2 жыл бұрын

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.
📑 VBA Source Code and File Download: learndataanalysis.org/source-...
📺 Also check out my 2nd channel Excel channel focus on sharing Excel tips: / @jjpowerbi
Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
🔑 PayPal Me: www.paypal.me/jiejenn/5
🔑 Venmo: @Jie-Jenn
💼 Join Robinhood with my link and we'll both get a free stock 🤝 join.robinhood.com/jiej6
Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
Patreon: / jiejenn
By shopping on Amazon → amzn.to/2JkGeMD
More tutorial videos on my website → LearnDataAnalysis.org
Business Inquiring: KZfaq@LearnDataAnalysis.org
#Excel #ExcelTip #ToggleButton

Пікірлер: 28

@GabrielAlmeida12 2 жыл бұрын

You are a greatest programmer. Best!! Thanks!

@jiejenn 2 жыл бұрын

Glad the video helped.

@gregorytaylor2749 2 жыл бұрын

This is genius!! Thanks!

@dangerousdon1987 7 ай бұрын

Fantastic !!!

@petermanesh7515 2 жыл бұрын

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

@powerguru9987 2 жыл бұрын

Perfect

@diegobermudez6639 2 ай бұрын

Thanks for sharing! This is great.

@jiejenn 2 ай бұрын

👍👍👍

@tobi9192 Жыл бұрын

thanks bro

@aakashkrsinha 2 жыл бұрын

Wow Jie 👍🏻👍🏻👍🏻

@kesavguru415 2 жыл бұрын

Amazing 😀😦

@platinumtoast99 2 жыл бұрын

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

@GabrielAlmeida12 2 жыл бұрын

Really very good!

@MrPantburg 2 жыл бұрын

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".

@denniswagner2788 Жыл бұрын

Have you figured out how to replicate this feature multiple times in the meantime? If so, could you please share :)

@merinrenjith4204 Жыл бұрын

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

@jiejenn Жыл бұрын

I charge a service fee of $100 USD. Let me know if you still want my help.

@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?

@mlzorb Жыл бұрын

I figured it out ... I checked the edit objects box under FORMAT Protect Sheet options. Worksheet is now locked out and the Toggle button WORKS! (phew!)

@jiejenn Жыл бұрын

Glad you figured it out.

@QNag Жыл бұрын

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

@sameerh3111 2 жыл бұрын

your video is great but I can not see what you are typing in formula bar. can you please write it into the description Thank you for your valuable sharing

@jiejenn 2 жыл бұрын

You can download the exercise file from the link in the description.

@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.

@jiejenn Жыл бұрын

Hard to tell. But one thing I would check is to make sure the object property size is set to locked.

@kaironbeau6241 2 жыл бұрын

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?

@jiejenn 2 жыл бұрын

Thisworkbook.activesheet

@kaironbeau6241 2 жыл бұрын

Oh thank you. It solve the problem. My eyes is getting blurry.