Ideas? statusbar not updating for VBA FUNCTIONS - works OK for VBA SUB

[BGExcel56]

I am trying to send a progress message from a custom VBA function - I get no errors, just never see the messages on the status bar. I have stepped through the function and confirmed the display command is executing. I can run a SUB from this same workbook/module and see the status bar updated.

Any ideas on what I can try to fix this are appreciated. Section of code below
(NOTE: I added the "DEBUG" status bar message to drive the message for each instance of the function being performed... also, Application.Displaystatusbar = False is not clearing the statusbar. It is almost as if all status bar functions are being ignored)
Thanks

Application.DisplayStatusBar = False
Application.DisplayStatusBar = True

Dim lngRow As Long
Dim intMod As Integer

lngRow = Application.Caller.Row
Application.StatusBar = "DEBUG:" & lngRow
intMod = lngRow Mod 500
Application.StatusBar = "Progress: " & lngRow & "/" & intMod
If intMod = 0 Then
Application.StatusBar = lngRow
End If

 

[mole999]

to return status bar to normal reporting use application.statusbar = "" as you exit the sub

 

[BGExcel56]

Thanks for your reply - I finally came across a thread in a different forum that seems to confirm that displaying the status bar from a UDF (User Defined Function) does not work (which sort of makes sense). I'll need to redesign my approach any way as the performance of the current design is not sustainable.
Thanks again