Loading

C# COM call from VBA

Suvasis Sikder

15y1.8k.NET

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 ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suvasis Sikder15y ago
thanks...i tried that earlier but was not working due to some reason..but now its working...strange..but anyways thanks...
Vulpes15y ago
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.