Help, Progress bar with multiple macros

Hi, I have a quick question. I have a large program i wanted to add a progress bar to. I have done so but dont know how to make the progress bar update when i call a macro from within a macro... For example... here is some code from my program


sub calling_Macro()

Dim PB As clsProgBar
Set PB = New clsProgBar


frmExportData.Hide

With PB
.Title = "Preparing Import please wait...."
.Caption2 = ""
.Caption3 = ""
.Show

For nCounter = 0 To 3

.Progress = nCounter
.Caption1 = "Percent Complete " & CStr(nCounter) & "%"

For lWaitCount = 0 To 1000000

If UserCancelled = True Then GoTo EndRoutine

Next lWaitCount

Next nCounter


Macro_called ' runs a subprogram which performs other functions

end with
.finish
end sub

What happens here is the progress bar updates fine as long as i update it within the one macro. But how do i update the same userform from a different macro. This progress bar is using a class and is from

www.enhanceddatasystems.com

please help

Thanks

i thought this would be pretty simple

have you tried dim the ProgressBar out side the sub routine? this
should make it a "Global" variable and allow other macros to access it.

Dim PB as clsProgBar

Sub.....

HTH

Die_Another_Day
greenfalcon wrote:
> i thought this would be pretty simple
>
>
> --
> greenfalcon
> ------------------------------------------------------------------------
> greenfalcon's Profile: http://www.excelforum.com/member.php...o&userid=13622
> View this thread: http://www.excelforum.com/showthread...hreadid=565273

have you tried dim the ProgressBar out side the sub routine? this
should make it a "Global" variable and allow other macros to access it.

Dim PB as clsProgBar

Sub.....

HTH

Die_Another_Day
greenfalcon wrote:
> i thought this would be pretty simple
>
>
> --
> greenfalcon
> ------------------------------------------------------------------------
> greenfalcon's Profile: http://www.excelforum.com/member.php...o&userid=13622
> View this thread: http://www.excelforum.com/showthread...hreadid=565273