Hi,
 I've written 5 functions each in its own module. I want to make one form with buttons on it and use click events to trigger the functions. What piece of code do I need to do this? I thought it would be something simple like Call Function(myfunction) but I haven't found anything that works yet.

Thanks,
Dave

If you have a function defined in a standard module like:

Public Sub MyFunction()
    MsgBox "MyFunction called."
End Sub

The click event on your form would call it like:

Private Sub Command0_Click()
    MyFunction
End Sub

Or you could use:

Private Sub Command0_Click()
    Call MyFunction
End Sub

MyFunction needs to be defined with public scope. All there us to it.

HTH,

Bob

Great! Thanks Bob that worked.
I knew it had to be something simple.
I had it set up like:

Function MyFunction()
Do this stuff
End Function

So I just changed Function to Sub and made it Public like you suggested and it works.
And best of all, I don't have to use any macros!

Thanks!:D