Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey, this is my first posting so bear with me...
I have embedded several checkboxes on a spread sheet and i wish to write code for the change event, but i can not figure how to get to it. I created the checkboxes through code: MySheet.OLEObjects.Add ("Forms.CheckBox.1") Set myOLEObject = MySheet.OLEObjects.Item(xx) myOLEObject.Name = "wkCheck" & x myOLEObject.Activate myOLEObject.Left = ActiveCell.Left myOLEObject.Top = ActiveCell.Top myOLEObject.Height = ActiveCell.RowHeight myOLEObject.Width = ActiveCell.Width myOLEObject.Object.Caption = "" How can i write into the VBA the change event code? I have played with VBE before, but am not too strong in that area. Please help. I want to kick off a query when the check box is changed to true. Thank you, James McDowell |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding a new template spread sheet on the first day of a new month | Excel Discussion (Misc queries) | |||
Adding intermittent rows to a spread sheet | Excel Discussion (Misc queries) | |||
Adding New Row to Excel Spread Sheet | Excel Worksheet Functions | |||
Adding New Row to Excel Spread Sheet | Excel Discussion (Misc queries) | |||
Screen is flashing when VBA adding objects into Excel sheet? | Excel Programming |