Why does not the function return property of the object?

[Wilker12]

Hello,
If the function returns the object property of the 1st form, how to make it also return from the 2nd?

1st form:

Function ValueOfCheckBox()
    ValueOfCheckBox = OLEObjects("CheckBox1").Object.Value
End Function
MsgBox ValueOfCheckBox

2nd form:

Function ValueOfCheckBox()
    ValueOfCheckBox = OLEObjects("CheckBox1").Object
End Function
MsgBox ValueOfCheckBox.Value

Thanks.

 

[Wilker12]

Original question made at this link.
https://www.excelforum.com/excel-pro...he-object.html

 

[Hui]

The second form is returning the Object, where the first form is returning the Value property of the Object

The object may have several other properties apart from just Value, ie: background Color, Font Color, Top, Left, Font type etc

The first form specifies what is wanted ie?: The Value

 

[Marc L]

Wild cross posting : see forums rules and read this !​

 

[Debaser]

You're missing Set:

Function ValueOfCheckBox()
    Set ValueOfCheckBox = OLEObjects("CheckBox1").Object
EndFunction

Of course, you should change the function name now.

 

[Wilker12]

Thanks, Debaser