Call events on any form without making event public.
Code can be modified for any type of control.
VB Code:
  1. 'IN A MODULE
  2. Option Explicit
  3.  
  4. Private Declare Function SendMessage Lib "user32.dll" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, _
  5. ByVal wParam As Long, lParam As Any) As Long
  6.  
  7. Private Const BM_CLICK As Long = &HF5
  8.  
  9. Public Function ClickAll(ByVal oForm As Form)
  10.  
  11.     Dim ctrlControl As Control
  12.     Dim sName As String
  13.    
  14.     For Each ctrlControl In oForm.Controls
  15.         DoEvents
  16.         'IF TARGET FORM IS THE HOSTING FORM THEN MAKE SURE NOT TO CLICK SELF
  17.         If TypeName(ctrlControl) = "CommandButton" And ctrlControl.Name <> "cmdClick" Then
  18.             SendMessage ctrlControl.hwnd, BM_CLICK, 0&, 0&
  19.         End If
  20.     Next
  21.    
  22. End Function
  23.  
  24. 'BEHIND FORM1 WITH FOUR COMMANDBUTTONS(Name Command1 = cmdClick)
  25. Option Explicit
  26.  
  27. Private Sub cmdClick_Click()
  28.     'YOU CAN USE THIS ON ANY FORM, JUST PASS THE TARGET FORMS NAME
  29.     Call ClickAll(Form2)
  30. End Sub
  31.  
  32. Private Sub Command2_Click()
  33.     MsgBox "Form1 Command2_Click"
  34. End Sub
  35.  
  36. Private Sub Command3_Click()
  37.     MsgBox "Form1 Command3_Click"
  38. End Sub
  39.  
  40. Private Sub Command4_Click()
  41.     MsgBox "Form1 Command4_Click"
  42. End Sub
  43.  
  44. 'BEHIND FORM2 WITH FOUR COMMANDBUTTONS
  45. Option Explicit
  46.  
  47. Private Sub Command1_Click()
  48.     MsgBox "Form2 Command1_Click"
  49. End Sub
  50.  
  51. Private Sub Command2_Click()
  52.     MsgBox "Form2 Command2_Click"
  53. End Sub
  54.  
  55. Private Sub Command3_Click()
  56.     MsgBox "Form2 Command3_Click"
  57. End Sub
  58.  
  59. Private Sub Command4_Click()
  60.     MsgBox "Form2 Command4_Click"
  61. End Sub