Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Mar 2003
    Location
    Cardiff, Wales
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel - Create a scrollable text box (97)

    I wish to place a number of text boxes in an Excel 97 spreadsheet - ideally as inserted links from Word.
    However I don't want them to be too large and would like them to be scrollable in the way that text boxes can be in Access. Any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel - Create a scrollable text box (97)

    1. The standard text box from the Drawing toolbar is scrollable, although it doesn't show a scroll bar.

    2. The text box from the Control Toolbox can have the look-and-feel you want: after you place the text box on a worksheet, you are in design mode. View the Properties window (there is a button for this on the Control Toolbox). Set MultiLine to True and Scrollbars to 2 - fmScrollbarsVertical.

    Ctrl+V will paste text into either type of text box. I don't know of a way to insert text from Word as a link into a text box. Anyone else?

  3. #3
    New Lounger
    Join Date
    Mar 2003
    Location
    Cardiff, Wales
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Create a scrollable text box (97)

    Thanks. The scrollable text box works well. I was trying to use a normal text box rather than the one in the Controls Toolbar.

    I see it is also possible to link the box to a cells' contents.

    I would still really like to be able to link the data to my Word document but can't seem to find a way.

    Is it possible to do this using VBA code?

  4. #4
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Create a scrollable text box (97)

    Dave:

    Select the text in Word and Copy. Select any cell in Excel (maybe on a different sheet) and Edit/PasteSpecial/PasteLink/Text. Then select this cell as the Linked Cell property of your text box. Changes in the Word text will be passed to the Excel cell, then to the text box - all without VBA!

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  5. #5
    New Lounger
    Join Date
    Mar 2003
    Location
    Cardiff, Wales
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Create a scrollable text box (97)

    Thanks Tony.
    I had worked out that method myself but I wasn't quite clear about what I wanted to achieve - which was to show the entire Word document in the text box.
    The paste link method copies each paragraph to a separate line and using concatenate to join them all is a bit of a pain!
    Also, the length of the Word files themselves might tend to change.

  6. #6
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Create a scrollable text box (97)

    Dave:

    "... I wasn't quite clear about what I wanted to achieve ..." Nor was I. <img src=/S/cool.gif border=0 alt=cool width=15 height=15> Might it not be easier to insert hyperlinks to the Word docs in your S/Sheet?

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

Posting Permissions

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