in einer Userform lasse ich Commandbutton erzeugen, wie kann ich
diesen dann ein Makro zuweisen?
Hintergrund ist, dass ich in einer UF mittlerweile über 500 Steuerelemente.
Danke!
Gruß, Ludmila
https://www.herber.de/bbs/user/89114.xlsm
Private Sub CMDH2_Click()
Z_Makro = CMDH2.Caption
Application.Run Replace(Z_Makro, " ", "_", 1)
End Sub
Option Explicit
Public WithEvents cmdButton As MSForms.CommandButton
Private Sub cmdButton_Click()
Dim Z_Makro As String
Z_Makro = cmdButton.Caption
Application.Run Replace(Z_Makro, " ", "_", 1)
End Sub
Dim aCommands(1 To 42) As New clsButton
in den 3 Start-Prozeduren vor Next ii: Set aCommands(ii).cmdButton = objcmdButton
Set aCommands(ii + 29).cmdButton = objcmdButton
Set aCommands(ii + 37).cmdButton = objcmdButton
Gruß
Private Sub CommandButton_Click()
Z_Marko As String
Z_Makro = CommandButton.Caption
Application.Run Replace(Z_Makro, " ", "_", 1)
End Sub
Gruß