Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    text boxes II ('97)

    Is there an easy way to tag a bunch of text boxes on a sheet in order to make a global change to them?
    Right now I hold down the shift key, but when there are many text boxes on a sheet, it is a bit of a pain.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: text boxes II ('97)

    You can select all objects on a sheet:

    F5 (goto), special, objects. But it will also select other objects.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

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

    Re: text boxes II ('97)

    Click the "Select Objects" button on the Drawing toolbar (in the default layout, it's the second button, displaying a NorthWest arrow).
    Drag a rectangle fully enclosing the text boxes you want to modify. If necessary, you can then use Shift+click to select or deselect individual objects.

  4. #4
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: text boxes II ('97)

    Thanks for the help

  5. #5
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: text boxes II ('97)

    Thanks.
    That's just what I needed.

Posting Permissions

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