Help, Progress bar with multiple macros
 

Hi, I have a quick question. I have a large program i wanted to add
progress bar to. I have done so but dont know how to make the progres
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 updat
it within the one macro. But how do i update the same userform from
different macro. This progress bar is using a class and is from

www.enhanceddatasystems.com

please help

Thank

--
greenfalco
-----------------------------------------------------------------------
greenfalcon's Profile: http://www.excelforum.com/member.php...fo&userid=1362
View this thread: http://www.excelforum.com/showthread.php?threadid=56527

Help, Progress bar with multiple macros
 

i thought this would be pretty simpl

--
greenfalco
-----------------------------------------------------------------------
greenfalcon's Profile: http://www.excelforum.com/member.php...fo&userid=1362
View this thread: http://www.excelforum.com/showthread.php?threadid=56527

Help, Progress bar with multiple macros
 

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