How to count how many times a form button that has a macro assigned to it has been clicked!?

Question

Hello everyone,&nbsp;I need your help with something, I was searching for a way to count how many times a form button has been clicked knowing that the form button has a macro assigned to it.Also while searching I found this code and couldn't really understand it nor know how to use it for my requestAny ideas, please?&nbsp;Dim clicked As Integer 'Declare global integerSub buttonClicked() clicked = clicked + 1 'Function to increase +1 End SubSub Button1_Click() buttonClicked 'Here call the function on each button clickMsgBox clickedEnd Sub

hansvogelaar · Accepted Answer

EzzEldean&nbsp;
I also replied to your PM.
The variable clicked is declared above and outside the macros, so it is "known" to all macros in the same module.
The macro buttonClicked takes the current value of the variable clicked, and adds 1 to it.
So the first time buttonClicked is called, the value of clicked increases from the default value 0 to 1; the second time it increases from 1 to 2, etc.
Sub buttonClicked()
    clicked = clicked + 1 'Function to increase +1
End Sub
The macro Button1_Click is assigned to the Forms command button Button1. It calls buttonClicked, increasing the value of clicked by 1, then displays the value of clicked in a message box.
Sub Button1_Click()
    buttonClicked 'Here call the function on each button click
    MsgBox clicked
End Sub

&nbsp;

Forum Discussion

How to count how many times a form button that has a macro assigned to it has been clicked!?

Share

Resources