Determining if Excel VBA macro still running?

[ElPresidente]

Hi everyone,

I had a macro I wrote in VBA which created several dozen spreadsheets
based off a master spreadsheet. Code runs smoothly in VBA, but trying
to port it over to VB caused significant performance issues. I decided
the best way would be to just run the VBA macro from VB.

The problem I'm having is that the macro takes some time to run and
there's no indication of progress on the VB form I created. I would
like to write something that would indicate the macro is being
executed and create a message box when the process is completed. I'm
still new to VBA and VB so any help would be appreciated.

 

[Melissa Nava]

Some ideas:

An idea is that you could possibly create a txt file and then log an
occasional message to that file during the process so that you can
fairly easily determine that it is working.

A module that tells the user that the macro is processing. Same type
of an idea of an error log, but the messages would show to the user on
the computer that the code is running.

A pop-up box that tells the user that it is running.

Perhaps a process bar indicator on a module might work - something
that shows the user how far through the process they are.

Depends on how you want the program to show the user that the
processes are working... You have lots of options.

Melissa