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.

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

On Apr 18, 11:49*am, Dave Peterson <peter...@verizonXSPAM.net> 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

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 <peter...@verizonXSPAM.net> 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