C# COM call from VBA

Question

I have created a COM dll in C# and consuming it in a Excel VBA code. I am not able to send a variable as a reference from the VBA code to the COM dll code. Can anyone please let me know the interface declaration that I should do in the C# code to accept variables as pointers so that the new value reflects in VBA code ?

Suvasis Sikder · Answer

thanks...i tried that earlier but was not working due to some reason..but now its working...strange..but anyways thanks...

Vulpes · Answer

The C# method will need to specify that the parameter is passed by reference (i.e. precede it with the 'ref' keyword) rather than by value which is the default. Any variable which is passed in from the VBA side should then contain the new value when the method returns.