LinkBack URL
About LinkBacks
Somewhere I had read or saw a video of a method to create clickable boxes with Excel, but I forgot where it is. If you can find this resource then please tell me? Anyway, how would you make clickable boxes?
Somewhere I had read or saw a video of a method to create clickable boxes with Excel, but I forgot where it is. If you can find this resource then please tell me? Anyway, how would you make clickable boxes?
Do you mean buttons or checkboxes? - VIEW->Toolbars->Control Box or VIEW->Toolbars->Forms
This will give you the toolbar for buttons or checkboxes...you can add macros to them or have them export a TRUE / FALSE value.
I help because of the Pavlovian dog that resides in the inner me...so if you are happy with the results, please add to my reputation. It helps keep me motivated!
Please mark your threads as Solved once it is solved. Check the FAQ's to see how.
Here's a spreadsheet that I use to present different types of checkboxes. Take a look and if you have any questions, let us know. I prefer using cells as Checkboxes over the ControlToolbox or Forms but they are all presented.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I clicked on view but there was no Toolbars - Help??? Thanx, I not very good with computers.Originally Posted by GuruWannaB
ChemistB, I like your workbook, but you are wrong about a control checkbox not being linkable to a cell.
If you can't figure out how a formula works, try stepping through it using "Evaluate Formula" in the Formula Auditing menu item in the tools menu!
If you want to see where your code went wrong, try stepping through it by clicking in the code and pressing F8 and watch as the magic happens!
If you are happy with any of the results, please add to the contributor's reputation by clicking the star icon.
Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
My bad. I'll fix that on my workbook. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks