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

Probably not, that would be considered entering a formula, so if you
selected A1, A1 text will become "This is the One", thus showing in the
formula bar, but of course every time you selected A1 it will get writen
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

--------------------


--
Stringer
------------------------------------------------------------------------
Stringer's Profile: http://www.thecodecage.com/forumz/member.php?userid=117
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65781