Results 1 to 14 of 14

Thread: Application.Caller return value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #8
    snb
    Guest
    No rocket science.

    Alternative Code:

    Private Sub CommandButton1_Click()
        M_snb 1
    End Sub
    
    Private Sub CommandButton2_Click()
        M_snb 2
    End Sub
    
    Sub M_snb(y)
        UserForm1.Caption = OLEObjects(y).Name
        UserForm1.Show
    End Sub
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •