Prev: Cells Fill Automatically on Another Workbook
Next: Counting independent items in a list
From: sarndt on 15 Mar 2010 14:19
How do I add a textbox control to a frame object (declared as OLEObject) in
vba code behind a worksheet?

For example, I have tried the following that doesn't work...

Dim objFrame As OleObject
Set objFrame = ActiveSheet.OLEObjects.Add(ClassType:="Forms.Frame.1")
With objFrame
.Object.Controls.Add ClassType:="Forms.Textbox.1"
End With
 | 
Pages: 1
Prev: Cells Fill Automatically on Another Workbook
Next: Counting independent items in a list