Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing a command button from being clicked twice
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing a command button from being clicked twice
NDBC wrote:
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 Another idea is to disable the StartButton after it is clicked: StartButton.Enabled = False Then set the value to True after satisfying some condition (e.g., when the StopButton is clicked, if you have such). If you want to keep counts you can create a module- or form-level variable that you increment in the button click event. Do this by declaring said variable at the top of the module, just under "Option Explicit" (if you have that) and prior to any subs or functions. Don't forget to reset this variable appropriately. You might not actually need to store a backup copy of start time if you try out the above ideas, but if you want to do it anyway you can store it in another module- or form- level variable, or write something like Range("AZ999").Value = Range("A6").Value Just make sure this line is not called on subsequent clicks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing a command button from being clicked twice
I would suggest to disable the start button once the user click start and if
the user want to stop let there be another button to do that. When they hit stop OR when the macro ends you can enable the start button. If this post helps click Yes --------------- Jacob Skaria "NDBC" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |