drop down list

[dc135custom]

Ok I tried approaching this another way I still want to control the color of the text in two diffetent text boxes, not cells, that act as stamps (see "drop down box" question dated Jan 11 2005). How can I write the macro to basically say "if" you choose one entry in the drop down list it will turn the text in one text box black (visible) and the text in the other text box white (invisible) and visa versa "if" the other entry is chosen? I put the if in quotes because I see this as being an if statement. Hoping this made sense.

Rick

 

[jdc]

Hi

You might find this useful, instead of turning the text white, or invisible as you say, it will still be noticeable if the text goes over gridlines.

some code to put in the Sheet window

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Sheet1.Range("A1") <> "" Then
ActiveSheet.Shapes("Text Box 1").Visible = True
ActiveSheet.Shapes("Text Box 2").Visible = False
Else
ActiveSheet.Shapes("Text Box 2").Visible = True
ActiveSheet.Shapes("Text Box 1").Visible = False
End If
End Sub

You can hack this about as you please,

John