Search found 1 match

by dilly
Wed Apr 05, 2006 10:55 am
Forum: ActiveX
Topic: adding control at runtime in Excel using VBA
Replies: 1
Views: 2675

adding control at runtime in Excel using VBA

what is the correct way to add the control at runtime? In excel using VBA i use this: Dim oleObj As OLEObject Dim strChartName As String strChartName = "something" Set oleObj = ActiveSheet.OLEObjects.Add(ClassType:="TeeChart.TChart", Left:=150, Top:=300Width:=500Height:=375) oleObj.name = strChartNa...