Macro to copy same 3 cells repeatedly

Hi Folks,

I am a fairly experienced Excel user who has never delved into Macro's, but recently started a fun project for myself & whilst I am pretty sure they are the solution, I simply cannot make it work the way I want. Here is the scenario...

I am developing a tool for someone to record live player stats during basketball games that I coach. My aim is to have a form with a range of buttons on it, each button represents a player & an activity, ie a row of buttons for Player 1 that each represent a shot,a rebound, a steal, etc

My recording solution thus far has been to create a column with players names & another column with each of the stat items that I wish to record. I also want to record time. Below is the code that I have recorded via the standard Excel macro record function

Please Login or Register  to view this content.

I can assign this macro to a button & when I hit the button the first time the macro runs just fine, & records the infor exactly where & how I expect, but the second time I run it it takes the values for the cells in the next row & each additional time it moves down a row again, whereas each time I want it to use the same data again & again. What have i not included?

Alos Icannot get the time to display in seconds - I think it is something in my machine as I have selected the correct format in Excel, but it will only go to minutes. Idealy I would have it display a time simce the sqart of the game & in theory I know how to do that, but I 'll worry about that next...

thanks in advance

James

jsnoz,

Please post your workbook - see "Manage Attachments".


Have a great day,
Stan

jsnoz,

Welcome to the forum.

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.

Originally Posted by shg

jsnoz,

Welcome to the forum.

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.

That's easier said than done... I did actually read the rules, but quite honestly I do not know how to describe what I want to achieve in few enough words - short of saying "recording hoops stats" which I felt was less appropriate than the option I chose.

If I had sufficient knowledge to describe exactly what I needed to do, or what in fact the problem was, maybe I could do it without asking for help

Thanks for welcome!

BTW I've had a go, but not convinced it say what I need it to! Cheers

jsnoz,

Having a problem with your attached workbook.

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Press and hold down the 'ALT' key, and press the 'F11' key.

Insert a Module in your VBAProject, Microsoft Excel Objects

Copy the below code, and paste it into the Module1.

Please Login or Register  to view this content.

Select, click on a cell with a players name and number.

Then run the below macro.


Or, try this macro assigned to your "Miss" button under "2 pt shot".


Have a great day,
Stan

jsnoz,

See the attached worbook "Stat Sheet Testing - jsnoz - SDG.xlsm".

Test the four buttons on sheet "Data Entry Form".


Have a great day,
Stan