What's wrong with this?
The Forms Toolbar does not have a TextBox control on it... you will need to
use either the one from the Drawing Toolbar or from the Control Toolbox
Toolbar instead.
--
Rick (MVP - Excel)
"sarndt" wrote in message
...
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
|