Software Archive
Read-only legacy content
17061 Discussions

display message in the excel status bar

Intel_C_Intel
Employee
329 Views
Can someone point me to an example of how to display messages
in the excel status bar.
I'm calling fortran routines from excel VBA and want to display
progress messages.

Thanks,

Brian Murphy
Austin, Texas
0 Kudos
3 Replies
Intel_C_Intel
Employee
329 Views
For an easy route to displaying a progress bar from a DLL routine, see the DLLPRGRS CVF sample.
One (not too difficult) way to display progress messages in the status bar is passing a callback function to the f90 dll routine. Thef90 routine periodically calls the VB callback routine passing progress info. The VB callback updates and refreshes the statusbar. You may want to look at the CVF CALLBACK sample.

IMO, the shipping CVF samples are a resource that is way under-utilized by users. It helps to be familiar with C:Program FilesMicrosoft Visual StudioDF98samplessamples.htm.

Hmm, here's a suggestion for the newsletter - a column that reviews one or two of the samples each issue to help draw attention to them. What d'ya think?

hth,
John
0 Kudos
Steven_L_Intel1
Employee
329 Views
Are you volunteering, John? :-)

Steve
0 Kudos
Intel_C_Intel
Employee
329 Views
Damn, I've got to be more careful how I phrase things! That should have read '...here's a suggestion for Steve about the newsletter...' ! :-)

What the heck, Steve. Give me some advance warning wrt timing and I'll see what can be done... :)

-John
0 Kudos
Reply