How do I change a buttons contents depending on a cells contents?

[Guest]

I need to change the contents (and format if possible) depending on the
contents of a cell... If possible, the button would only display in certain
cells contained data.

Is this possible?

Thanks,

Tim

 

[Guest]

some thing like this in the Sheet Object where the button is located:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Range("C3") = "Hello" Then
ActiveSheet.Shapes("MyBtn").Visible = True
'vba seems to require selection before formatting, so:
ActiveSheet.Shapes("MyBtn").Select
With Selection.Font
.FontStyle = "Bold"
.Size = 10
.ColorIndex = 3
End With
Target.Select
Else
ActiveSheet.Shapes("MyBtn").Visible = False
End If
Application.EnableEvents = True
End Sub

 

[Guest]

Makes sense...

Many thanks,

Tim