How can I receive the multi return values from DLL in VBA(Excel Visual Basic)?

Now, I'm currently trying to receive the multiple return value from DLL in VBA(Excel Visual Basic).

This is my DLL code.

Please Login or Register  to view this content.

Then I want to give some value to the DLL by using the datain0 and datain1 and receive the dataout0 and dataout1 from the DLL in the VBA(Excel Visual Basic).

This is my VBA code.actually, I'm not familiar with VBA(Excel Visual Basic)

Please Login or Register  to view this content.

What am I supposed to make the function which is what I want to give datain0=3, datain1=4 and receive the dataout0 and dataout1 values?
If I run the above code in the excel, I've got a problem halt

Your dll function is modifying the variables passed to it using ByRef (data2 and data3) so your function pll_dll_excel should return those values as an array instead of passing the returned 0 from the dll. This is how you should be using the ByRef variables - I have just created a fake pll_dll function for demonstration.... when you pass Cells() you are only passing the value and not the cell object so you cannot write directly to it.

Please Login or Register  to view this content.

[QUOTE=Bernie Deitrick;4602389]Your dll function is modifying the variables passed to it using ByRef (data2 and data3) so your function pll_dll_excel should return those values as an array instead of passing the returned 0 from the dll. This is how you should be using the ByRef variables - I have just created a fake pll_dll function for demonstration.... when you pass Cells() you are only passing the value and not the cell object so you cannot write directly to it.

Please Login or Register  to view this content.

Is this correct?

No.

You cannot have a Function Sub ("Function Sub useSquareInVBA() ")

Try just using the dll function directly - your dll already uses ByRef:

Please Login or Register  to view this content.

Have you updated your declaration line?

Please Login or Register  to view this content.

Originally Posted by Bernie Deitrick

Have you updated your declaration line?

Please Login or Register  to view this content.

Dear Bernie,
This is my C code
q8.JPG

ans the below code is the VBA code

Please Login or Register  to view this content.

The problem is that I can get the any string data from dll.
Would you please help me please?

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

It might be an issue with C, but I don't know C - sorry. You might want to start a new thread.