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.
Original question made at this link.
https://www.excelforum.com/exc…operty-of-the-object.html