View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sarndt sarndt is offline
external usenet poster
 
Posts: 37
Default What's wrong with this?

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