Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run multiple macros | Excel Discussion (Misc queries) | |||
Macros across multiple files | Excel Programming | |||
Select from multiple macros | Excel Programming | |||
customised printing of multiple pivot charts & tables - unsure how to progress | Excel Programming | |||
macros in multiple worksheets | Excel Programming |