UserForm Toggle Button Code

Good afternoon,

Can anyone tell me if it is possible to make a toggle button' text appear as "Yes" when depressed and "No" when not?
If you know and will provide the code would you please include in the code the placement of the text "Yes" or "No" relative to the aforementioned process onto the spreadsheet?

Thank you much, in advance.
(I always search for hours or even days before asking a question - it helps me edumacate myself)

JasonRay

Please Login or Register  to view this content.

Thank you Forum stnkynts.
Can you share the code to get the results onto the spreadsheet?

Thank you Forum Guru.
Do you know and/or can you share the code to get the results onto the spreadsheet?

what results onto the spreadsheet? Do you mean adding a toggle button?

No. If the toggle states "yes" then I would like for it to input "Yes" into a specific cell within the WorkSheet, same for "no" also. The toggle is designed to add a yes or no to a specific cell.
Thanks for your help.

What specific cell?

Oh, let's say B5, (5,2) on WorkSheet1.

I assumed the first worksheet was called "Sheet1". If not you will need to change code to match your sheet name:

Please Login or Register  to view this content.

Thank you very much Stnkynts.
JasonRay

Thanks to you also Shu.