Search found 1 match
- 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...