Invoking a function in Excel+VBA code from a DLL

Hi,

I need to invoke a VBA function from a dll.

My scenario is as follows.

I'm working with Excel and have a Smart Tag menu(my own written in a dll). I want to invoke a VBA function when the user clicks on any of the menus.

Is this possible ?? If yes then pl. help.

Regards,

Sudarsan.

Welcome to the Forums.

Depends if you exposed it in your dll. If so you go to the VBA Editor
and add a reference to your dll. Then you should be able to
access the functions in it.

HTH