Single-line procedures

[Stevenn]

I have sub procedures which only contains one line, e.g. frmUserForm.Show. Is it possible to write a sub function in a way like

Public Sub MySubProcedure(arg As Double): frmUserForm.Show

the code above results in an error because I haven't ended the procedures correctly.

 

[Joe4]

I think you still need to have the "End Sub" statement. You can do it like this:

Public Sub MySubProcedure(arg As Double): frmUserForm.Show: End Sub

</PRE>

 

[Stevenn]

I think you still need to have the "End Sub" statement. You can do it like this:

Public Sub MySubProcedure(arg As Double): frmUserForm.Show: End Sub

Thank you. It works