Code with code

[MagicalDean]

How can I get a function (in a JavaScript stylee) in VBA, to save me having to have the same code in five different places? I also want to know how to have variables, so something like function(variable 1, variable 2) which I can use to put in data from the made code into the other code, or the function

If that made ANY sense to anyone, their help is greatly apprechiated

 

[alvechurchdata]

Read "Function" and "Sub" in help.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[MagicalDean]

I'm trying but this help sucks Can you please give me an example or a link or something?

 

[GingerR]

i simply googled and there's tons of help out there:

http://www.functionx.com/vbaccess/Lesson05.htm

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244