<div>
No, because the Static variable is local to the sub in which it is defined.<br />
<br />
You would have to make intCounter a module level variable and simply reset it:<br />
<br />
Dim intCounter As Integer<br />
<br />
Private Sub Commandbutton28_Click()<br />
&nbsp; intCounter = intCounter + 1<br />
&nbsp; MsgBox &quot;Clicked&quot; &amp;&nbsp;&quot; &quot;&nbsp;&amp; intCounter<br />
End Sub<br />
<br />
Private Sub cbRefresh_Click()<br />
&nbsp; &nbsp; intCounter = 0<br />
End Sub
</div>


No, because the Static variable is local to the sub in which it is defined.

You would have to make intCounter a module level variable and simply reset it:

Dim intCounter As Integer

Private Sub Commandbutton28_Click()
  intCounter = intCounter + 1
  MsgBox "Clicked" & " " & intCounter
End Sub

Private Sub cbRefresh_Click()
    intCounter = 0
End Sub

<div>
<div class="content wysiwyg-content">
I am using Excel VBA<br />
<br />
Is there any way to clear the static event when you click the Refresh Button?<br />
<br />
Any help would greatly be appreciated!<br />
<br />
Private Sub Commandbutton28_Click()<br />
Static intCounter As Integer<br />
intCounter = intCounter + 1<br />
MsgBox &quot;Clicked&quot; &amp;&nbsp;&quot; &quot;&nbsp;&amp; intCounter<br />
End Sub<br />
<br />
Private Sub cbRefresh_Click()<br />
<br />
<br />
End Sub
</div>
</div>


I am using Excel VBA

Is there any way to clear the static event when you click the Refresh Button?

Any help would greatly be appreciated!

Private Sub Commandbutton28_Click()
Static intCounter As Integer
intCounter = intCounter + 1
MsgBox "Clicked" & " " & intCounter
End Sub

Private Sub cbRefresh_Click()


End Sub

Clear a Static Event

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.