Morning
I have a main sub which calls 11 other subs whithin my module to run all my code
What im trying to do is create a progress bar or some form of userform message status which shows how far along it has gone
i.e
Updating
-Calculating AHT.. (for which whichever stage it is at)
or simply
Progress 0-100%
Tried looking online but quite new to VBA so cant find an example of how to do this with my 'Runall' sub
not looking for a bottomleft statusbar update as want it to appear a message on screen
all help would be greatly appreciated! Thank you
I have a main sub which calls 11 other subs whithin my module to run all my code
Code:
Sub Runall()
'calling all my subs
Call UniqueDates
Call CallsTaken
Call CreateCol
Call AHT
Call WrapUp
Call HighWrapColumn
Call HighWCount
Call HighWrapPercent
Call ShortCalls
Call SortTableCalls
Call ExtractHWCalls
End Sub
What im trying to do is create a progress bar or some form of userform message status which shows how far along it has gone
i.e
Updating
-Calculating AHT.. (for which whichever stage it is at)
or simply
Progress 0-100%
Tried looking online but quite new to VBA so cant find an example of how to do this with my 'Runall' sub
not looking for a bottomleft statusbar update as want it to appear a message on screen
all help would be greatly appreciated! Thank you