Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding text in a cell | Excel Worksheet Functions | |||
FINDING DUPLICATE TEXT IN 2 COLUMNS!!!!! | Excel Discussion (Misc queries) | |||
Finding text within text | Excel Discussion (Misc queries) | |||
Finding Specific Text in a Text String | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |