View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim McLeod Jim McLeod is offline
external usenet poster
 
Posts: 14
Default 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...