overtime
09-12-2004, 09:13 AM
Hi All,
i need some help ,
i have managed to add a button to a sheet, but i cant add to it a click method.
xlButtonShmoo = ws.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False _
, DisplayAsIcon:=False, Left:=486.75, Top:=14.25, Width:=231, Height _
:=24.75)
AddHandler DirectCast(xlButtonShmoo, Button).Click, xlButtononClick()
Please help....
i need some help ,
i have managed to add a button to a sheet, but i cant add to it a click method.
xlButtonShmoo = ws.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False _
, DisplayAsIcon:=False, Left:=486.75, Top:=14.25, Width:=231, Height _
:=24.75)
AddHandler DirectCast(xlButtonShmoo, Button).Click, xlButtononClick()
Please help....