Results 1 to 2 of 2

Thread: Excel textboxes

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2000
    Location
    Derby, England
    Posts
    1
    From VB5 I can add a text box to an Excel worksheet using
    With xlSheet.Shapes.Addshape (msoShapeRectangle,100,200,50,50)
    . Name = "Box1"
    end with
    But I cannot find out how to place text in the text box
    Can anyone advise
    Regards Dave Puttock
    [email protected]

  2. #2
    Fanatic Member
    Join Date
    Jan 2000
    Location
    Nitro
    Posts
    633

    Try this.

    Code:
        ActiveSheet.Shapes("Rectangle 1").Select
        Selection.Characters.Text = "af"
    Chemically Formulated As:
    Dr. Nitro

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width