Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro in Excel
I "designed" a score-board (for biljart) in Excel.
I would like to add a knob to go back to a blanc score when a new match starts. What are the instructions that I have to put in the macro linked to the knob ? (I have no experience in this programming matter). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro in Excel
Walter
If you have no experience it may be very unwise to give scant guidance here. The one thing I would say is that if the data does not change places. (That is no cutting/pasting/row or column adding), you could record yourself deleting the old scores ToolsMacros...Record new macro. Make sure it is set to record in 'This Workbook and you can then assign it to a toolbar button -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "walter.vbn" wrote in message ... I "designed" a score-board (for biljart) in Excel. I would like to add a knob to go back to a blanc score when a new match starts. What are the instructions that I have to put in the macro linked to the knob ? (I have no experience in this programming matter). |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro in Excel
A non-macro approach.
Select your cells that need to be reset (to 0's or blanks????). Then give that selection a nice range name (Insert|name|Define). When you want to clear/zero out those scores, just F5 (edit|goto) and select that name. Hit the delete key (to clear) or type 0 and hit ctrl enter to fill with 0's. == If you wanted a button to run a macro, you could do it with one of these lines: ActiveSheet.Range("myScores").Value = 0 or ActiveSheet.Range("myscores").ClearContents (I named the range of cell "myScores") "walter.vbn" wrote: I "designed" a score-board (for biljart) in Excel. I would like to add a knob to go back to a blanc score when a new match starts. What are the instructions that I have to put in the macro linked to the knob ? (I have no experience in this programming matter). -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming |