How would I put a check mark in a cell by clicking on that cell??
How would I put a check mark in a cell by clicking on that cell??
You could add a checkbox from forms
Or you could add a macro that puts a letter in the cell when it is selected (or removes a letter if there is one) then change the cell font to show checkmarks.
Either of these appeal to you?
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
Im trying not to put an object in the cell. So the macro seems like the way to go.
1.On the Insert menu, click Symbol.
2.In the Symbol dialog box, on the Symbols tab, in the Font box, click Wingdings.
3.Scroll to the bottom of the list, where you will find several common check mark symbols. Double-click the symbol that you want .
Thanks
Thameem.
Try this:
Change the Range C2:C6 to match your clickable check box areaPlease Login or Register to view this content.
Change the font of said are to Wingdings
Paste the above into the worksheet code (right click sheet tab, view code, paste into white space, close the VB editor)
Click
Thanks Thameem but I think I'm going to need a macro for what I'm trying to acomplish.
Your welcome! Record macro and follow the same steps.
Last edited by thameem127; 02-14-2013 at 12:55 PM.
CC,
The macro works perfect. The only problem is I dont know how to get it toexecute by clicking on the cell.
I was a bit brief with this instruction:
Change the Range C2:C6 to match your clickable check box area
The macro has a line in it with an area (C2:C6) - replace this with the address of the area you want to click to check/uncheck then it should work perfectly.
Make sure you are putting all the code from my window into the sheet - the first line is important as it is the automatic trigger instruction.
Sorry aboutbeing so brief. I think you understood perfectly. here is my code. It only executes if I hit enter after clicking on the cell.
Please Login or Register to view this content.
Sorry aboutbeing so brief. I think you understood perfectly. here is my code. It only executes if I hit enter after clicking on the cell.
Please Login or Register to view this content.
Compare the first line of your and my macro (starting Private Sub...)
Thanks. I didnt look at that close enough.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks