Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thank you and what you wrote tell me that I have so much to learn. I can see where I need to place the code you wrote, and have made some progress. but..
Do the command buttons go in the Control box? How are the Player-Name-Score cells linked to the control box? My end goal is to transfer this spreadsheet to my ipaq PDA to keep a running score. PS. How long did it take you to learn all of this? I am way impressed as I am self taught. Thanks again, I will try working on figuring it out. Happy 4th of July "Marcotte A" wrote: Make sure you select the player first, so as to assign a number to the Player variable. Also, you can abstract the points buttons somewhat with this: Sub AddNum() Dim NumToAdd As Integer Select Case Application.Caller Case "Button 1": NumToAdd = 50 Case "Button 2": NumToAdd = 100 End Select With Cells(Player, 3) .Value = .Value + NumToAdd End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tennis Scorecard Help | Excel Worksheet Functions | |||
scorecard | New Users to Excel | |||
Supplier scorecard | Excel Discussion (Misc queries) | |||
golf scorecard | Excel Discussion (Misc queries) | |||
ScoreCard | Excel Programming |