What's wrong with this?
Well - I've played with this further. I can add a control toolbox frame to
the worksheet in display mode, but I can't add it using the code below in the
Worksheet_change event where I trying to add the frame.
Set objFrame = Activesheet.OLEObjects.Add(classtype:="MSForms.Fra me")
Steve
=================
"sarndt" wrote:
In VBA Code behind a worksheet
Dim objFrame As OleObject
Dim objTextBox As OLEObject
Set objFrame = ActiveSheet.OLEObjects.Add(ClassType:="Forms.Frame .1")
Set objTextBox =
ActiveSheet.OLEObjects(objFrame).Add(ClassType:="F orms.Textbox.1")
Frame is created. But Textbox statement errors out - and doesn't get
created inside of Frame
Thanks
Steve
|