| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing text on a shape
Hi
Why does this line cause an error ? If Sheets("Control").Shapes("Type1").Characters.Text = "OUTCOMES" Then C = 2 But this does not cause an error? ActiveSheet.Shapes("Type1").Select If Selection.Characters.Text = "OUTCOMES" Then .... I would like to check the text on a shape which represents a button without having to activate the sheet and select the shape first. Any help appreciated on this one. Andrew Bourke Perth, Australia |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Testing text on a shape
? Sheets("Control").Shapes("Type1").TextFrame.Charac ters.Text = "OUTCOMES"
True ? Sheets("Control").Shapes("Type1").TextFrame.Charac ters.Text OUTCOMES -- Regards, Tom Ogilvy "Ajtb" wrote in message ... Hi Why does this line cause an error ? If Sheets("Control").Shapes("Type1").Characters.Text = "OUTCOMES" Then C = 2 But this does not cause an error? ActiveSheet.Shapes("Type1").Select If Selection.Characters.Text = "OUTCOMES" Then .... I would like to check the text on a shape which represents a button without having to activate the sheet and select the shape first. Any help appreciated on this one. Andrew Bourke Perth, Australia |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Testing text on a shape
Thanks Tom!
Tom Ogilvy wrote: ? Sheets("Control").Shapes("Type1").TextFrame.Charac ters.Text = "OUTCOMES" True ? Sheets("Control").Shapes("Type1").TextFrame.Charac ters.Text OUTCOMES |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User form - Testing for numbers or text | Excel Discussion (Misc queries) | |||
| my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
| Shape colour set according to text value | Excel Discussion (Misc queries) | |||
| Testing for text | Excel Programming | |||
| Testing for text | Excel Programming | |||
Linear Mode
