show cell value in menu bar (or status bar)

Dear experts,

I have a idea on how to do this.
I created a new menu, and want to change the menu text with the value.
looking now on changing menu text with VBA

Kind regards

Eric

Hi
One simple idea is to use the title bar
Application.Caption = ActiveCell.Value

or the status bar
Application.StatusBar = ActiveCell.Value

Regards,
Stellan

Another option, depending on your version of excel (2002 and above) would be to use the Watch Window (View>Toolbars>Watch Window) and to set a watch on the cell(s) you want to keep an eye on.

Of course, I forgot about the Watch Window. That is a very nice solution. Thank you nutsch!
/Stellan

Hi to all,

thanks for the solution so far. the menu bar option is best for me.
I have to following problem with this.
I have to hide the workbook from viewing. I run a webquery on my investment and it would be better if the sheet containing all the figures would be unvisible but still updating the web query, and there I found lies the problem. One's a sheet is hidden the web query no longer updqtes in back ground. Does any one now a work arround that. all I want to show is the gain or loss in e percentage on the menu bar (or caption of excel...) but updating

Thanks Eric

Hi Eric
That is a different question. I have no experience from running web queries. I suggest that you ask a separate question about this issue.

Regards,
Stellan

Thanks Stellan,

I accepted you anwer about the menu bar and will pose another question forquery update.


Kind regards,

Eric

Hi Eric
I am glad that you liked my answer but I could not see that you have accepted it.

Regards,
Stellan