Running VB from Switchboard

[BillDickenson]

Yes, this is a rookie question but since I am almost done with this project, hopefully close to my last idiot level question.

How do I run a VB procedure from the Switchboard. I can't seem to get the RUNCODE to work. I've created a shadow macro to match each one, but there has to be a more rational way to do this. I've hunted through a couple of books without success.

Thanks

 

[WhiteZiggy]

you should be able to call the code by simply :

"Call ImportValues"

.

Make sure your procedures are public.

WZ

 

[BillDickenson]

Ouch, I never thought of using "Call".

Thanks