AutoExec macro runing VBA function

K

KentAE

Hi,
As I understand, AutoExec macro can only run VBA function not Sub. My be
somebody are able to perform how a such function looks like?
Thank' in advance
 
W

Wayne Morgan

For the most part, the difference between a sub and function are small.

Sub:
Public Sub MyRoutine()
'code here
End Sub

Function:
Public Function MyRoutine() As String
'code here
MyRoutine = "SomeValue"
End Function

A function can return a value, a sub can't. The function doesn't have to
return a value if you don't want it to. If you have a sub that is doing what
you want, just change the first and last lines to say Function instead of
Sub. Also, change any Exit Sub statements to Exit Function. You will now be
able to call it from the macro.
 
Top