formula bar caption

F

filo666

hi there, is there a way to change the formula bar caption, something like:

if target.address = "$A$1" then application.formulabar.caption="This is the
one!!!"

pd. I am not interested in cell comments, just in the formula bar caption.

thanks
 
S

Stringer

Probably not, that would be considered entering a formula, so if yo
selected A1, A1 text will become "This is the One", thus showing in th
formula bar, but of course every time you selected A1 it will get write
with that text.

Here is an example as well you could use the status bar.


Code
-------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)


If Target.Address = "$A$1" Then Target = "This is the One"

'or use the status bar
Application.StatusBar = False
If Target.Address = "$A$1" Then Application.StatusBar = "This is the one!!!"
End Sub
 
Top