• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

toggle buttons

G

gizmo

New Member
I'm trying to make a dashboard that uses they dynamic chart with check boxes, however, check boxes are too small. How can i use a toggle button instead. I'm not good with VBA but might could muddle through. I can do macros. Help..i need to look like a rock star.;)
 
You do not need vba to have toggle buttons.


From developer tab, insert active x control - toggle button.

Then right click on it, choose properties. (You need to be in design mode)


Set target cell, caption and other properties as you want.


See the image and download workbook for an idea.


http://chandoo.org/img/playground/toggle-button-example.xls


http://chandoo.org/img/playground/toggle-button.png
 
You must log in or register to reply here.
Back
Top