default parameter value

C

clara

Hi,

How to set a default parameter value in the defination of a sub

for example :

sub outputreport( reportname as string, Datatype as string = "" )

end sub
Clara

thank you so much for your help
 
E

Elwin

I think what you're looking for is optional parameters, which carry default
values.

Sub OutputReport(Optional strReportName as String = "MyReport", _
Optional strDataType as String = "" )

End Sub

good luck!
 
T

Tim Ferguson

sub outputreport( reportname as string, Datatype as string = "" )
Click to expand...

Look up help on the Optional keyword

public sub OutputReport _
( ReportName As String, _
Optional DataType As String = "" _
)




Hope that helps


Tim F
 
Top