right click on the sheet tab,
Select view code

Select the worksheet, then calculate event from the dropdowns at the top of
the module

Private Sub Worksheet_Calculate()
Application.StatusBar = me.Range("B9").Value
End Sub

or if it would only change based on user entry, use the change event.

--
Regards,
Tom Ogilvy



"ilopango" wrote in message
.. .
Tom Ogilvy wrote:

Actually, split windows sounds like the solution you want. Split them
horizontally and then make the low portion small and scroll to the data
you
want displayed. Unfortunately, you can't both freeze and split. The
only other would be to make your window a window (not maximized) and
then
do
Window, New Window. Take the new window and position it under the first
window, size it and scroll to the area you want to display.

Ok. I prefer the statusbar option, but tell me, if I used, in case of the
value change of the cell, this will continue to change in the status bar?
My problem is not programming, it's knowledge of VBA, i don't know the
objects, i don't even know that they exist. I guess, once I get use to all
objects, my questions will end.. sorry about all the questions..

Fernando