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
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".
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?
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!)
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
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?
You are a greatest programmer. Best!! Thanks!
Glad the video helped.
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
Sounds great. What voice did you use for the video?
Really very good!
Fantastisk funktion.
Er der en mulighed for at du sender den eller jeg kan doawnload det?
På forhånd tak
Thanks for sharing! This is great.
👍👍👍
Fantastic !!!
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".
Have you figured out how to replicate this feature multiple times in the meantime? If so, could you please share :)
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?
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!)
Glad you figured it out.
Wow Jie 👍🏻👍🏻👍🏻
Perfect
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
You can download the exercise file from the link in the description.
Tone is realistic. Delivery is noticeably robotic.
Hi great video. Could you please help me with the code to add this toggle button to another 6 worksheets as well?
I charge a service fee of $100 USD. Let me know if you still want my help.
This is genius!! Thanks!
thanks bro
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.
Hard to tell. But one thing I would check is to make sure the object property size is set to locked.
Amazing 😀😦
Run-time error '1004': Method 'Range' of object '_Worksheet' failed......it then highlights this line: If .Range("ToggleValue").Value = True Then
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?
Thisworkbook.activesheet
Oh thank you. It solve the problem. My eyes is getting blurry.