Place a checkmark with a single mouse click?

**HuntnPeck** · 12-06-2008, 07:53 PM

I have a worksheet that I use to monitor the progress of student interns. They are assigned 20 different tasks and recieve 5 points for each task they complete, for a possible total of 100. In my worksheet, I record their progress and maintain a running total. I do this by simply inserting the number "5" by each cell containing each task. Instead of inserting the value, what I'd prefer to do is simply place my cursor, click the mouse button, and have a formattable check mark appear with a hidden value of "5". I'm simply trying to create a snazzy interface. Do I want too much? Or is it actually possible to do this?

**Dave69rock** · 12-07-2008, 12:27 AM

Hi

Please see the attached sheet maybe this will get you started

Dave

**JBeaucaire** · 12-07-2008, 03:48 AM

Just a note, you don't actually need to keep "fives" totalling in the B column, even if you're going to hide them. The check marks in the Marlett font is enough info to get the count, too.

Just create your column of checkmarks, you said 20 items, right? So set the Worksheet Range to cover those 20 cells. Then at the bottom, or wherever, just use the formula:

Please Login or Register  to view this content.

...to get the total of "checkmarks" and 5 pts for each.

Now, if you set your checkmarks up in ROWS instead of columns, then it would look something like:

Please Login or Register  to view this content.

**HuntnPeck** · 12-07-2008, 09:21 AM

Thank you for the courteous responses. Your assistance with this is greatly appreciated. However, my goal is a bit more ambitious. I want to place my cursor over a designated cell and cause a check mark to appear with the simple click of a mouse button. I also want that check mark to have a value of 5 points. I'd even like to use a checkmark image that can be formatted for best visual appeal.

Here's the challenge:

1. Create a checkmark image that can be formatted.
2. Cause certain cells to display that checkmark when they are selected by the cursor.
3. Provide that checkmark image with a value of "5".

I'd like to know if this can be done and how to go about it. Thanks again.

**JBeaucaire** · 12-07-2008, 10:54 AM

Everything you just described is provided for in Dave's answer and mine. Both sample workbooks we've uploaded show exactly what you've described, his in vertical format with a separate scoring column, and mine in horizontal format with an integrated scoring formula.

**HuntnPeck** · 12-07-2008, 01:01 PM

I must be doing something wrong. I copied and pasted the exact code you provided, but changed the range to accomodate my worksheet. When I click on a cell, nothing happens. If I enter the number "5", a small triangle appears (with a value of 5). I know nothing about VBA, so I may be misunderstanding the proper way to insert the code. I highlighted my worksheet number and used the "Worksheet" and "Selection Change" catagories, just as it appeared in your attachment. Did I follow the correct procedure?

**JBeaucaire** · 12-07-2008, 01:55 PM

What's your range? Or just post the sheet.

**Dave69rock** · 12-07-2008, 02:12 PM

Hi

Check your security settings to run macros

Goto Tools>Macro>Security If its set as High then you need to add the site in the Trusted sources or change to medium or low.

The sheet is no longer adding the number 5's it's counting the letter "a" then times by 5. if you type in the letter "a" you will see what i mean.

Let me know if this helps

Dave

**shg** · 12-07-2008, 02:18 PM

... or change to medium or low.

You seriously never want to set Macro Security to Low.

**HuntnPeck** · 12-07-2008, 03:42 PM

Originally Posted by Dave69rock

Hi

Check your security settings to run macros

Goto Tools>Macro>Security If its set as High then you need to add the site in the Trusted sources or change to medium or low.

The sheet is no longer adding the number 5's it's counting the letter "a" then times by 5. if you type in the letter "a" you will see what i mean.

Let me know if this helps

Dave

Yep. I typed an "a" into one of the designated cells and when I hit ENTER, it changes to a checkmark. Does that indicate what I've done wrong?

**Dave69rock** · 12-07-2008, 04:14 PM

Hi

That means the code is working fine

Dave

**Dave69rock** · 12-07-2008, 04:17 PM

Post a sample of your workbook

**HuntnPeck** · 12-07-2008, 05:32 PM

Originally Posted by Dave69rock

Post a sample of your workbook

It's still in development, but here's part of it...

**Dave69rock** · 12-07-2008, 06:10 PM

i can't open the file are you using windows 2007?

If so save it as an earlier version

Dave

**HuntnPeck** · 12-07-2008, 06:42 PM

Originally Posted by Dave69rock

i can't open the file are you using windows 2007?

If so save it as an earlier version

Dave

Yes, I'm using Excel 2007. Here's the earlier version you requested. Thanks for the assistance.

**Dave69rock** · 12-07-2008, 07:31 PM

its not working because the cells are merged

I'm sure the code could be changed to accommodate merged cells but i'm not sure how to do it just yet, i can work on it, but looking at your sheet there seems no reason to merge cells D & E just have the student name in cell D

Dave

**HuntnPeck** · 12-07-2008, 08:09 PM

Originally Posted by Dave69rock

its not working because the cells are merged

I'm sure the code could be changed to accommodate merged cells but i'm not sure how to do it just yet, i can work on it, but looking at your sheet there seems no reason to merge cells D & E just have the student name in cell D

Dave

Thanks, Dave. I had the cells merged to accomodate the student's first and last name. Once I "unmerged" them, your code worked very well. I'd really like to learn more about developing codes. As you can see, I've got much to learn. Thanks again for all the help.

Place a checkmark with a single mouse click?

LinkBack

Thread Tools

Rate This Thread

Display

Place a checkmark with a single mouse click?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions