View Single Post
 
Old 05-17-2020, 03:28 PM
gmaxey gmaxey is offline Windows 10 Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,427
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

Code:
Sub EditPaste()
  MyEditPaste
End Sub

Sub MyEditPaste(Optional varPassed As String)
  If Not varPassed = vbNullString Then
    MsgBox varPassed
  Else
    Selection.Paste
  End If
End Sub

Sub OtherRoutine()
  MyEditPaste "Test"
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote