Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching for text within shapes
Hello all,
My wife has an excel workbook with an org chart created on one sheet. The org chart corresponds to a table on an different sheet, meaning the names in the table are also plotted on the org chart. She wants to be able to change any shape on the org chart from a rectangle to an oval based on criteria in the table. My problem is that the find function in excel apparently searches through cells and not shapes. Does anyone have a suggestion how to search for text captured within a shape? I didn't find any methods or properties of the shape object that would appear to work. Art |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching for text within shapes
What version of excel ?
Tim On Feb 19, 6:11*pm, c1802362 wrote: Hello all, My wife has an excel workbook with an org chart created on one sheet. The org chart corresponds to a table on an different sheet, meaning the names in the table are also plotted on the org chart. She wants to be able to change any shape on the org chart from a rectangle to an oval based on criteria in the table. My problem is that the find function in excel apparently searches through cells and not shapes. Does anyone have a suggestion how to search for text captured within a shape? I didn't find any methods or properties of the shape object that would appear to work. Art |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OnAction bei vielen Shapes ... ich meine sehr viele Shapes? | Excel Programming | |||
searching for shapes | Excel Programming | |||
Code for searching & copying Text from 1 text file to another | Excel Programming | |||
Alternative Text for shapes | Excel Programming | |||
Text on shapes | Excel Programming |