How do you pass a variable to a function in vba

[jlitondo]

I have a function which is called from several different forms' sub-routines, but I don't know how to pass a table name variable for example from the form to this function in code.This would be nice to do as it would eliminate duplication of this code in all these forms.Anyone?

 

[Telsa]

Create a public variable in its own Module. That might work. Then you would share that variable with all forms.

HTH

Mary

 

[tarekm]

Hi;
I used the following and it worked:

I defined a variable ToggleVar as public and a sub (or function) as public in a separate module as follwoing:

Public ToggleVar As Integer

Public Sub FilterToggle(Formname As Form)

Then I called this sub from different forms by using the follwing statement:

FilterToggle Me

In this way I passed the current form to the public sub.

Hope it will work with you

Tarek

 

[jlitondo]

I set up my code like tarekm and modified it to fit program needs and it worked fine.Thanks alot.