Example: Using Function and Sub Parameters in VBA

UsingParameters.vb

Function CreateProposal(clientName As String, 
                          clientId As Integer, 
                             title As String, 
                          subtitle As String, 
                       projectName As String,
                        reportDate As Date, 
                        preparedBy As String,
                        reviewedBy As String,
                        authoredBy As String, 
                          fontSize As Integer) As Boolean
  
  ''
  '  Logic goes here...
  
End Function