Show Hide Button if specific text is displayed in cell

[DaveOver]

I want to hide or show "Button 27" depending on the text displayed in a Cell D25.

The Button is called "Button 27"

I want "Button 27" to be "Visible - True" if the text in "Cell D25" has this entry "To be stored in Teamcenter"

I want "Button 27" to be "Visible - False" if the text in "Cell D25" does not say "To be stored in Teamcenter"

 

[SteveO59L]

how does cell D25 get changed?

 

[DaveOver]

D25 is changed in accordance with the following formula after selecting a document type from a LOV in cell D10..

="To be stored in"&" "&VLOOKUP(D10;'Document Details'!B3:D97;3;FALSE)

 

[SteveO59L]

something along the lines of

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("d25") = "Yes" Then
ActiveSheet.Shapes.Range(Array("Button 2")).Visible = False
Else
ActiveSheet.Shapes.Range(Array("Button 2")).Visible = True
End If
End Sub

 

[DaveOver]

Steven,

Thanks very much...

I used this variation of your suggestion and it works perfectly.

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("d25") = "To be stored in Teamcenter" Then
ActiveSheet.Shapes.Range(Array("Button 27")).Visible = True
Else
ActiveSheet.Shapes.Range(Array("Button 27")).Visible = False
End If
End Sub

Have a great day.
DaveO

 

[SteveO59L]

thanks for the feedback