If statement on Command Button Click

[Pacman52]

Hi all,
Is it possible to have an If statement to check if a command button has been clicked? I've tried the line below but it doesnt seem to work.

If cmbBut1 = True Then

Many thanks for any responses. Paul

 

[skillilea]

I think you need to trap it

try this

Private ButtonClicked As Boolean

Private Sub CommandButton1_Click()
    ButtonClicked = True
   
    DoWork
End Sub


Private Sub DoWork()
   ' do something
   
    ' reset whenever
    ButtonClicked = False
End Sub

Private Sub OtherStuff()
    If ButtonClicked Then
   
    Else
   
   
    End If
End Sub

 

[Pacman52]

Hi thanks so much for the quick reply I'll give that a go later tonight when back home. One question though what is the purpose of the Sub 'DoWork' ? just so I understand what its meant for.

Thanks again Paul

 

[Micron]

So that you can see how to interact with the variable that holds the setting. Your request is a bit vague to me. What should happen when clicked 2nd, 3rd, etc. time? Why does this even matter when there is an event that will run when clicked, which probably makes something happen. Would you not then know it was clicked because that something happened? That 'something' could probably tell you it was clicked by changing the button caption in that event.

Not that there's anything wrong with the suggestion, but another method would be to change the Tag property of the button. With that you could even have a count of clicks.

 

[Pacman52]

I think you need to trap it

try this

Private ButtonClicked As Boolean

Private Sub CommandButton1_Click()
    ButtonClicked = True
  
    DoWork
End Sub


Private Sub DoWork()
   ' do something
  
    ' reset whenever
    ButtonClicked = False
End Sub

Private Sub OtherStuff()
    If ButtonClicked Then
  
    Else
  
  
    End If
End Sub

Just to let you know that did the trick thanks again for the reply and help.

Paul

 

[skillilea]

You are welcome!

 

[Pacman52]

So that you can see how to interact with the variable that holds the setting. Your request is a bit vague to me. What should happen when clicked 2nd, 3rd, etc. time? Why does this even matter when there is an event that will run when clicked, which probably makes something happen. Would you not then know it was clicked because that something happened? That 'something' could probably tell you it was clicked by changing the button caption in that event.

Not that there's anything wrong with the suggestion, but another method would be to change the Tag property of the button. With that you could even have a count of clicks.

Thanks for the reply and explanation - I was trying to sort out a userform 'cancel' button to run a yes / no msgbox and to run a 'Stop' on all the other msgboxes if a user opted for Yes. A bit more complex than that but it worked for what I needed so all is ok.

Paul