Macro - running VBA function

  • Thread starter Nelson The Missing Lead
  • Start date
N

Nelson The Missing Lead

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
 
S

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
[email protected]
 
M

Marshall Barton

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


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