?Tally chart using buttons???

[smithymcsmithy]

Hi everyone,

I am an excel newbie and struggling at the moment.

Im trying to create a tally chart using buttons on sheet 1. Each user clicks the button and is automatically counted on sheet 2. There are at least 10 buttons. I've included a sample excel for what I want. I need to log this by date, looking at a 7 day spread. Also if possible each time a button is clicked it saves automatically. This will have multiply users on a shared drive. Could someone explain this in newbie lingo to me

Any help would be greatly appreciated, thanks in advance.

[xladept]

1 2 3 4
5 9 10 11
12 6 8 7

This is the order of your buttons - it would be better if they were in numerical order - since this is just an example, will your real spreadsheet have the "buttons" in order??

(Also, these are all standard controls - and, as such, are limited to just the click event).

[smithymcsmithy]

Thanks xladept for the response.

I only know how to draw shapes :o/

They can be in numerical order, as long as i can re-name them in the future.

Hope this helps

[xladept]

Hi smithymcsmithy,

It doesn't matter since I'm keying on the "Caption" - see if this is what you want:McSmith.xls

[smithymcsmithy]

This is spot on for what I want It worked perfectly till I messed about with it :o/ I tried to change the Violet tab to Animal. Is this possible so in the future I can change the names? Also I know Im pushing my luck but is there a way to make them look like buttons and signal when clicked? Thanks again for what you have already done

[smithymcsmithy]

Ive added what I have done.

[xladept]

For some reason your "Animal" got placed as "Animal " - I fixed it with this:

Please Login or Register  to view this content.

McSmith.xls

[smithymcsmithy]

You my friend, are a legend

[xladept]

Hi smithymcsmithy,

I've been playing with some "button" effects - see if you like it:

Please Login or Register  to view this content.

[smithymcsmithy]

Im not sure how to get this code into the sheet :o/

[xladept]

Hi smithymcsmithy,

Just copy paste the code into the module over the old code - but I changed it again - try this: McSmith.xls

[smithymcsmithy]

This is great, I must be doing something wrong though. Every time I change the name in button 1 to anything I get the debug, I change it on sheet 2 and the debug, however if I change it back to red it works.

---------- Post added at 01:17 PM ---------- Previous post was at 01:16 PM ----------

Sorry to be a pain

[xladept]

Change it in the code like I did with "Button" #10:

Please Login or Register  to view this content.

[smithymcsmithy]

Have a look at this vid if you get a chance. Im still having trouble.

http://www.youtube.com/watch?v=E9X7d...ature=youtu.be

[xladept]

Hi smithymcsmithy,

Don't do it that way - after you've entered:

Please Login or Register  to view this content.

in the right place, just keep hitting "F8" (the function button F8 on your keyboard)

this will single step through the program and, hopefully, highlight the problem code.

I can't say why you're having trouble as it works clean on my system.

[xladept]

I just realized - "Aquamarine" has to be an entry in Column "A" - that's the way it's programmed! Want to reprogram it??

[smithymcsmithy]

No this is fine for what I want for some reason it wouldnt work on home computer however at work fine. Running 2010 at home and 2007 and work maybe thats the issue I dont know but thanks again for the help.

[xladept]

Good and you're welcome!