Macro - running VBA function

[Guest]

Hi,

When i create a macro to run some VBA function.....but the programme can't
find my VBA function....why???

Please help.....thank...

Nelson Chou

 

[Steve]

Put your function in a standard module under the Modules tab in the database
window.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Marshall Barton]

When i create a macro to run some VBA function.....but the programme can't
find my VBA function....why???

The function must be decalared Public and be in a standard
module (not a form/report/class module).