In my excel module1 file:
When I type the following formula in a cell: =showx(abc()) all I get is a #VALUE! error
I'm expecting Excel to show a value of 1 in that cell
Why is that? I'm desperate!
Code:
Public Type punto
x As Double
y As Double
z As Double
End Type
Public Function abc() As punto
abc.x = 1
abc.y = 2
abc.z = 3
End Function
Public Function ShowX(pp As punto) As Double
ShowX = pp.x
End Function
I'm expecting Excel to show a value of 1 in that cell
Why is that? I'm desperate!