Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Finding a text box

I would like to be able to find text boxes on a large spreadsheet.

I understand each graphic is given a "name" which resides in the name
box. Is there a way of using any kind of find command to find it. E.g
if I typed in the cell B23432 "Ben" and went to the find command and
typed in "Ben" it would find it for me. But if I had a text box in
which was the name Ben and tried to find it it wouldnt. Even if I
called the text box Ben it wont find that either which is frustrating.

Any suggestions?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,081
Default Finding a text box

The functionality of this approach is inversely related to the # of text
boxes, but you can simply press the F5 key, click on Special, then on
Objects, and OK. Then the tab key will cycle between the objects (text
boxes) on the sheet

" wrote:

I would like to be able to find text boxes on a large spreadsheet.

I understand each graphic is given a "name" which resides in the name
box. Is there a way of using any kind of find command to find it. E.g
if I typed in the cell B23432 "Ben" and went to the find command and
typed in "Ben" it would find it for me. But if I had a text box in
which was the name Ben and tried to find it it wouldnt. Even if I
called the text box Ben it wont find that either which is frustrating.

Any suggestions?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding text in a cell Art Excel Worksheet Functions 8 December 3rd 06 06:47 PM
FINDING DUPLICATE TEXT IN 2 COLUMNS!!!!! HERNAN Excel Discussion (Misc queries) 0 October 16th 06 05:59 PM
Finding text within text Jambruins Excel Discussion (Misc queries) 0 March 20th 06 05:04 PM
Finding Specific Text in a Text String Peter Gundrum Excel Worksheet Functions 9 April 10th 05 07:21 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"