Which userform command button was clicked (VBA)

[haseft]

hi,
how do I find wich command button was clicked?
help with this please.

Dim i As Long
n = 11
For i = 1 To 6
  If UserForm3("cmb" & i) was clicked then ?????
    'do something
  Else
    'do something
  End If
  n = n + 1
Next

 

[haseft]

I can’t see that I have Class1 on the menu.

 

[haseft]

I am really sorry DanteAmor,
Different language on VBA (Class1, Klass1).
It works greate.
Tanks again for your support.

One more issue:
Is it possible to exclude one or more CommandButton?
For example: get massage when you press CommandButton with the name cmb1, cmb2 and cmb3, but not for cmb4, cmb5 etc (all are in the same userform).

 

[DanteAmor]

Try this:
In the Case line write the names of the buttons you want to include
Case "CommandButton1", "CommandButton2", "CommandButton4"

Dim colButton As Collection 'Collection of Button      'This to the top of all the code.

Private Sub UserForm_Initialize()
  Dim ctrl As MSForms.Control
  Dim clsObject As Class1
  
   'Create New Collection To Store Custom
  Set colButton = New Collection
  For Each ctrl In Me.Controls
    If TypeName(ctrl) = "CommandButton" Then
      Dim m
      m = ctrl.Name
      Select Case ctrl.Name
        Case "CommandButton1", "CommandButton2", "CommandButton4"
          Set clsObject = New Class1
          Set clsObject.Button = ctrl
          colButton.Add clsObject
      End Select
    End If
  Next
End Sub

 

[haseft]

It works greate.
Tanks again DanteAmor for your support.

 

[DanteAmor]

Glad we could help & thanks for the feedback