Why does not the function return property of the object?

Wilker12 · Jul 15th 2018

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

1st form:

Code

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

2nd form:

Code

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

Thanks.

**Kenneth Hobson** · Jul 15th 2018

Code

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

Wilker12 · Jul 15th 2018

Perfect, Kenneth! :thumbcoo:

Participate now!