Assigning click event to OleObjects checkbox
Dear group
How is it possible to assign a click event to a checkbox that has been placed within a worksheet using the following code..
Dim OleObjectsObject As OLEObject
Dim OleControl As OLEObjec
Dim CheckBox As MSForms.CheckBo
Set OleControl = OleObjectsObject.Add(ClassType:="Forms.CheckBox.1"
Set CheckBox = ExcelWorkSheet.OLEObjects(OleControl.Name).Objec
Best regards
Jim...
|