setting an object's property to an object

[whburling]

WHEN SETTING AN OBJECT'S PROPERTY TO AN OBJECT
runtime code fails to work, but no compiler error.

Here is the code that correctly reads the cells of a worksheet
and successfully places the values into an object (verified via debugger)

Please Login or Register  to view this content.

Here is the line of code that seeks to place the above object,FieldDataCoordinates,
into an object,Ptr2FieldData,

Please Login or Register  to view this content.

The above line executes. I can single step it through the "let" code in the Ptr2FieldData object:

Please Login or Register  to view this content.

When the above read code completes execution, the debugger
reveals the CoordinatesObj DID make it into the private storage of
the Coordinates property

but the debugger gives me the impression that it is not there by
indicating the public property of Ptr2FieldData.Coordinates does not exist
"object variable....not set"

Soooo....the code for reading the private data out must be at fault. I used "set" to define PMeasurementCoordinates.....do i have to something analogous in removing Coordinates?

Please Login or Register  to view this content.

What does that debugger error message mean? the code did execute.

[AlphaFrog]

I'm not sure what the problem is, but i have seen cases when variables are named using a VBA keyword like value can produce strange results. I recommend you change the value variable name. That may or may not address your problem.

Please Login or Register  to view this content.

[leelnich]

If it says the variable isn't set, then I'd look at the assignment statement. Which line was highlighted (if any)?

[shg]

I expect PMeasurementCoordinates is not an object, it's an instance of a user-defined type, so the Set should be replaced by Let (or removed).

[xlnitwit]

Hi,

If FieldDataCoordinates / CoordinatesObj is an object, you should use a Property Set and not a Property Let

Please Login or Register  to view this content.

and therefore

Please Login or Register  to view this content.

[whburling]

leelnich,

there is not line highlighted. the code fails to extract coordinates from the object and goes immediately to the end of the
main program. Does not stop anywhere.

[whburling]

SHG,

I checked to see what PMeasurementCoordinates is:

"Private PMeasurementCoordinates As CoordinatesClass" thus is not PMeasurementCoordinates declared as an object?

Here is the class:

Please Login or Register  to view this content.

[whburling]

XLnitwit.....
Thank you so much....your answer worked.
the key to my problem lay in my error:

Please Login or Register  to view this content.

which I corrected at your suggestion to :

Please Login or Register  to view this content.

Thank you.

now your other suggestion....interestingly worked with let as in my original posting:

Please Login or Register  to view this content.

and it worked with your suggestion

Please Login or Register  to view this content.

can you help me understand what the "set" does in the line:

Please Login or Register  to view this content.

I thank you again. ......

[xlnitwit]

Truth be told, it is largely convention that one uses a Set property procedure with objects (even Microsoft doesn't always do so however). If you use a Property Set, you must use Set when assigning the object to the property; if you use Property Let, you do not use Set when assigning the object to the property. You can, of course, declare both a Property Let and a Property Set if you so wish so that either syntax will work when assigning the object.

I am not entirely clear what your original issue was since the code in your original question seems to have changed since first posted.

[whburling]

xlnitwit,

For sure your code suggestions work. I am using both recommendations. I am very grateful you gave me your valuable time and stuck with my efforts to understand. My code works.

Thank you once again. You were ultra clear. Your assessment accurate. your suggestions helped me as you took the time
to actually write code using the same variables I was using...so your code made it easy for me to see what you were conveying to me.

Thank you.