Syntax Problem

[Geoff Taylor]

Hi,
Recorded code in Excel 2007
<code>
ActiveSheet.Shapes("Button 3").Select
Selection.Characters.Text = "Go"
</Code>

If I try to add this code into a select case statement I get a 438 error "Object doesn't support the property or method

<code>
Select Case ActiveSheet.Shapes("Button 3").Characters.Text
</Code>

 

[schielrn]

I think for it to work, you would have to do it this way unfortunately:

ActiveSheet.Shapes("Button 3").Select
Select Case Selection.Characters.Text


With shapes you typically always have to select them first and cannnot combine select statements with the following selection, I know it seems backwards from what everyone preaches about not seelcting .

Hope that helps.