Newbie,
I use two different methods to let the user know the code is executing.
One method is to use either the window or application Caption Property
or StatusBar Property to give a running dialog of macro status. For more
information about using the former, check the VBA help file. A typical
line of code might look something like:
Application.ActiveWindow.Caption = "Transferring data - " & _
Format(i / tskcount, "##%")
where "i" is an index for the current task object
The other is to use an hourglass as you suggest. For the latter (i.e.
hourglass), you will need to create a simple userform since that is
where the hourglass constant resides. For more information on that,
check the VBA help file on creating and using userforms. Once the
userform is set up I use the following code syntax:
frmCobra.MousePointer = fmMousePointerHourGlass
where Cobra is the name of my userform
Although I don't remember specifically, I believe these items are
addressed in the VBA tutorial which can be found on our MVP website at:
http://project.mvps.org/links.htm
Look for the link at the bottom of the page for, "Project 98 Visual
Basic Environment Training Materials". Even though it says it is for
Project 98 it is equally applicable to all current versions of Project.
John
Project MVP
