Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code to copy one VBA command button to another location:
Me.cmdFilterRow19.Copy Me.Paste Me.Cells(rngRow.Offset(-2, 0).Row, Me.Range("FilterMatrix").Column + 3) Me.OLEObjects("CommandButton1").Name = "cmdFilterRow" & rngRow.Offset(-2, 0).Row --- Now I know I can access the command button as either an OLE object or an MSforms.Commandbutton, but I can't find anyway to programmatically add '_click' event code to the new button. Is this even possible, or am I stuck using Excel Buttons for this situation? Thanks. -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Checkbox procedures | Excel Programming | |||
Get VBA procedures from DB | Excel Programming | |||
Event Procedures in an Add-In | Excel Programming | |||
VBA Sub procedures | Excel Programming | |||
ListBox Procedures | Excel Programming |