call user defined function on button click

[AunN]

Dear Programmers!

I want a help, as i m trying to call a user defined function on button call on form but i am not successful yet. Please give me some solution to this problem!!

I will be highly obliged to u all!

 

[boblarson]

The easy answer first:
If it has no parameters -

Private Sub CommandButtonNameHere_Click()
   NameOfProcedureYouAreCallingHere
End Sub

If it has parameters:

Private Sub CommandButtonNameHere_Click()
   NameOfProcedureYouAreCallingHere "ParameterHere", "SecondOneHere"
End Sub

What is the procedure you are trying to call? What is its code?

 

[vbaInet]

Can you show us the signature, that is the first line of the function?

It should be something like this:

Public Function SomeFunction()

That's the line we would like to see.

Edit: I'm pretty slow huh Bob

 

[harmankardon]

Can you describe to us what you have done so far? And what is the name of the function and the button? Without any further information I can't be of much help.

I can say that roughly the steps are to create your function, then in the OnClick event for your button you will need to call the function.

Example:

Private Sub myButton_Click()
     Call myFunction()
End Sub

I think the word Call is optional IIRC, but I usually include it for readability.

 

[harmankardon]

Yikes, I'm slower than I thought, there were no replies when I started mine.

 

[vbaInet]

Yikes, I'm slower than I thought, there were no replies when I started mine.

I've seen this happen before

 

[boblarson]

I've seen this happen before

Happens fairly frequently.

 

[vbaInet]

@boblarson: Haha! I'll blame it on the Super Mods putting a delay on the posts so that their posts can come first Kidding of course

 

[AunN]

Thanku programmers for the inputs it's done!