| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.StatusBar or equivalent for user defined functions
I would like to update the status bar from within a user defined
function. Application.StatusBar works for macros / subroutines, but does NOT work for user defined functions as best I can tell. Is there an equivalent call? Any help will be appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application.StatusBar or equivalent for user defined functions
Functions called from worksheet cells can't do this kind of thing.
About the only thing that they can do is return a value to the cell that owns the formula. Bob Nyholm wrote: I would like to update the status bar from within a user defined function. Application.StatusBar works for macros / subroutines, but does NOT work for user defined functions as best I can tell. Is there an equivalent call? Any help will be appreciated. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application.StatusBar or equivalent for user defined functions
On Apr 18, 11:49*am, Dave Peterson wrote:
Functions called from worksheet cells can't do this kind of thing. About the only thing that they can do is return a value to the cell that owns the formula. Bob Nyholm wrote: I would like to update the status bar from within a user defined function. *Application.StatusBar works for macros / subroutines, but does NOT work for user defined functions as best I can tell. Is there an equivalent call? Any help will be appreciated. -- Dave Peterson Thanks for your help - wishful think on my part. I also tried executing a subroutine from within the function to update the status bar, again without success. Like you say, the function umbrella is very restrictive. .......bob |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application.StatusBar or equivalent for user defined functions
And excel is pretty smart!
You can't fool it by hiding the code in subroutines of subroutines of subroutines <vbg. Bob Nyholm wrote: On Apr 18, 11:49 am, Dave Peterson wrote: Functions called from worksheet cells can't do this kind of thing. About the only thing that they can do is return a value to the cell that owns the formula. Bob Nyholm wrote: I would like to update the status bar from within a user defined function. Application.StatusBar works for macros / subroutines, but does NOT work for user defined functions as best I can tell. Is there an equivalent call? Any help will be appreciated. -- Dave Peterson Thanks for your help - wishful think on my part. I also tried executing a subroutine from within the function to update the status bar, again without success. Like you say, the function umbrella is very restrictive. .......bob -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| APPLICATION OR USER DEFINED ERROR | Excel Programming | |||
| User Defined Functions | Excel Worksheet Functions | |||
| User Defined Functions - Help Text - Make it Easy for the User | Excel Programming | |||
| User defined functions | Excel Programming | |||
| excel functions and User defined functions | Excel Programming | |||
Linear Mode
