Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros
Hello and How are you
I was wondering if anyone could help me with the code in macros in excel 97. What I have done is set up for a race and whenever someone crosses over the finish line the timer hits a button and the time is recorded. What is the code to make it go to the next line down (Vertically) so that the timer doesn't always have to have it on the right cell. Here is the code I have already done Sub Button1_Click() ' 'Button1_Click Macro 'Macro recorded 12/15/2003 by Jessica ' ActiveCell.Value = Time ActiveCell.NumberFormat = "hh:mm:ss" ' End Sub Thankyou and have a great day Jessica ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
List the Macros that can be executed from Tools-Macros | Excel Programming |