Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am using excel 2003 to keep lap times in a dirt bike race. I have a command
button that is clicked to record the time the race starts. The code is below. Private Sub StartButton_Click() Worksheets("Timing Sheet").Range("A6").Value = Format(Now, "h:mm:ss") End Sub What I need to do is to ensure that the button is not clicked accidently after the race has started. Is there a way that I can count how many times it has been clicked and if it is more than once it comes up with a warning along the lines of "the race has started are you sure you want to change the race start time" with a yes/no option. The other thing I would like to do is store a backup copy of the original start time somewhere else in the worksheet in a way that it is nopt updated every time the button is clicked. Any help will be gladly appreciated. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When clicked, the Button needs to create a number in another cell | Excel Worksheet Functions | |||
Change Macro button color after clicked | Excel Discussion (Misc queries) | |||
Excel 2007 Crashes Whenever Add-In Button is Clicked | Setting up and Configuration of Excel | |||
let a sub recognise the name of the button that has been clicked. | Excel Discussion (Misc queries) | |||
preventing button being pressed | Excel Discussion (Misc queries) |