View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ajtb Ajtb is offline
external usenet poster
 
Posts: 41
Default 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