Microsoft Office Tutorials and References
In Depth Information
14.7.2 Adding a Control to a Worksheet Programmatically
For instance, the code:
ActiveSheet.OLEObjects.Add ClassType:="Forms.Textbox.1", _
Left:=72, Top:=72, Height:=20, Width:=100
places a new text box approximately one inch from the top and left edges of the active worksheet.
(The dimensions do not seem to be terribly accurate.)
Search JabSto ::

Custom Search