Solved: Calling a Subroutine

[bopo]

Hi

Yet another question, basically lets say I have several exit buttons throughout my program, I create a little sub in a module which contains the coding.

Now could I have a small piece of coding which would link to the sub within the Module and execute it?

Thanks

[lucas]

[VBA]
Sub a()
name of the little sub in a module which contains the coding(one word)
end sub
[/VBA]

[Cyberdude]

Yep, except I might suggest you use "CALL subname" to remind you that it's a macro and not a variable. It helps the self documentation objective.
Sid

[bopo]

Hi

That works for form based buttons, however i was wondering if something can be used for buttons on UserForms?

[vba]
Sub a()
name of the little sub in a module which contains the coding(one word)
end sub
[/vba]

[lucas]

hi bobo...pretty basic stuff here...read your help files some ok?
[VBA]Private Sub CommandButton1_Click()
name of the little Sub In a module which contains the coding(one word)
End Sub[/VBA]
Sid is right too...probably a good idea to use call then the name of the macro

[geekgirlau]

In that case, the name of the sub-routine you're calling might be something like:

[vba]
cmdImport_Click
[/vba]

[lucas]

click is the key...Hi Anne

[geekgirlau]

Hiya Steve!