Here is a link to some code I posted way back in 1998 that shows how to
change the selection (and restore it)
http://tinyurl.com/2zzlve
in case you wanted to loop through the various functions.
--
Regards,
Tom Ogilvy
"L. Howard Kittle" wrote in message
. ..
Thanks Greg and Bob. Very interesting solutions. I appreciate the
responses.
Regards,
Howard
"L. Howard Kittle" wrote in message
. ..
Hello Excel users and Experts,
Excel 2003
Is there a way to display the worksheet status bar values of ADD, MAX,
AVERAGE, et al, via VBA code.
So if I select or reference a few cells with values in them, and have ADD
selected in the status bar can I get a Msgbox or something to display
that value?
And can you change the function of the status bar via VB code. So you
could present something like:
"The SUM of the cells is " 88
"The AVERAGE of the cells is " 33
"The MAX of the cells is " 108
Help on STATUS BAR gives a True or False relevant to displaying the bar,
but no help on displaying the value of the Status Bar.
I have no final goal for this. I found a curious solution in the
newsgroup that used keystrokes to SUM, AVG, etc. same colored formatted
cells with the value displayed in the Status Bar. Wondered if I could
reference the status bar value via code.
I have written my own non-pro code to sum color coded cells on a sheet
and I am aware of Dave McRitchie's true-pro code to do the same thing.
Thanks
Regards,
Howard