excel status bar area

[oldLearner57]

hi community

can community assist me on this matter...

when i do a sum or average on cell range, and is it possible to have the
function example, =sum(value+value) display on the excel status bar (the
bottome area of the excel interface)
and if possible,
can the display be adjusted


thanks community for the help

 

[Barb Reinhardt]

It would require VBA. When would you want it displayed? If you
recalculate? Which cells would you want displayed? Would you want the
formula displayed when you select the cell?

Lots of questions before you get what you want.

This *may* be a start. Right click on the sheet with the formula and
select VIEW SOURCE and paste this in. If you select the cell, you'll get the
equation in the cell. It doesn't give the values that make it up. THat
would require a good bit more code, I suspect.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub

Application.StatusBar = Target.Formula & "=" & Target.Value

End Sub

HTH,
Barb Reinhardt

 

[Dave Peterson]

Do you want to see that to help you write a formula?

If yes, you can start the formula (or function) you want, like:
=sum(
and hit ctrl-a to see the function wizard dialog.
or
hit ctrl-A (ctrl-shift-a) to see excel's "in-line help" like:
=sum(number1,number2,...)

By the way, newer versions of excel (I think xl2002, xl2003 for sure) can help
with little tooltips for the function that you're using.