Status Bar

Status Bar

Anonymous
Not applicable
1,109 Views
11 Replies
Message 1 of 12

Status Bar

Anonymous
Not applicable
Is it possible to show a status bar or something similar while a program is
running? Ideas for either VB6.0 or VBA would be much appreciated.
0 Likes
1,110 Views
11 Replies
Replies (11)
Message 2 of 12

Anonymous
Not applicable
I should rephrase my question : I need to display a progress (or status)
bar to show how much time is remaining in a certain procedure.
Randy wrote in message
news:[email protected]...
> Is it possible to show a status bar or something similar while a program
is
> running? Ideas for either VB6.0 or VBA would be much appreciated.
>
0 Likes
Message 3 of 12

Anonymous
Not applicable
Hi Randy,
In VB6, you can use a splash screen with a progress bar. There are already
activex progress bars built. You can access them by right clicking on an empty
area of the controls page in your toolbox (when a form or splash is being
constructed) and select additional controls. Splash screens in vba with
progress bars are a nice dream that come to programers on a good night, but
they're not yet a reality 😞 I've been close, but never successful. Although,
I haven't tried building a splash screen with progress bar in a dll and
wrapping it in vba,,,,,hhmmmm,,,
-Josh

Randy wrote:

> I should rephrase my question : I need to display a progress (or status)
> bar to show how much time is remaining in a certain procedure.
> Randy wrote in message
> news:[email protected]...
> > Is it possible to show a status bar or something similar while a program
> is
> > running? Ideas for either VB6.0 or VBA would be much appreciated.
> >
0 Likes
Message 3 of 12

Anonymous
Not applicable
In VBA, you can right-click on the 'Toolbox' 'Controls' palette, select
'Additional Controls' for additional *installed* controls. Scroll down and
there may be one or two labeled 'Microsoft ProgressBar Control'.
-- Walter -- http://www.ActiveDwg.com

Randy wrote in message
news:[email protected]...
> I should rephrase my question : I need to display a progress (or status)
> bar to show how much time is remaining in a certain procedure.
> Randy wrote in message
> news:[email protected]...
> > Is it possible to show a status bar or something similar while a program
> is
> > running? Ideas for either VB6.0 or VBA would be much appreciated.
> >
>
0 Likes
Message 3 of 12

Anonymous
Not applicable
Randy,
You can use the Microsoft ProgressBar Control
I use it in a userform with VB5
I think it is possible with VB6

Bernard
Randy a écrit dans le message :
[email protected]...
> I should rephrase my question : I need to display a progress (or status)
> bar to show how much time is remaining in a certain procedure.
> Randy wrote in message
> news:[email protected]...
> > Is it possible to show a status bar or something similar while a program
> is
> > running? Ideas for either VB6.0 or VBA would be much appreciated.
> >
>
0 Likes
Message 6 of 12

Anonymous
Not applicable
Attached you will will a splash screen that I made up completely within
AutoCAD VBA. No additional references to a status bar control needed. The
basic idea is to use two labels, one on top of another. Set one labels to be
sunken and the other to be raises. Change the color of the raised label to
what you want. I used blue. Then within your procedure, start the width of
the raised label as 0 and then index the width until completion. Here is
some sample code to place in your procedure. You'll have to do some work in
order for it to work for you.

Public Sub Program_setup()
Dim Steps as Integer
Steps = 5
For i=0 to Steps
Start.Progress.Width = (Start.Label2.Width-2) / Steps * i
DoEvents
'place code you want to execute
Next i
Unload Start
End Sub

"Progress" is the name of the raised label and Label2 is name of sunken
label
When the Splash screen form activates, it will call the Program_setup sub
procedure.

Just show the splash screen and everything should work on its own. The
progress bar on this example will whip across very fast. You may not be able
to notice it.

Hope you like the cheap and dirty trick,

Sergio DeAlbuquerque
President

Matrix Technical Services Inc.
172 N.Bicycle Path
Selden, NY 11784

Ph: 631-736-9001
Fax: 631-696-8538

http://www.matrixengg.com
[email protected]
"CAD services, machine design, and VBA application development"
0 Likes
Message 7 of 12

Anonymous
Not applicable
Attached you will will a splash screen that I made up completely within
AutoCAD VBA. No additional references to a status bar control needed. The
basic idea is to use two labels, one on top of another. Set one labels to be
sunken and the other to be raises. Change the color of the raised label to
what you want. I used blue. Then within your procedure, start the width of
the raised label as 0 and then index the width until completion. Here is
some sample code to place in your procedure. You'll have to do some work in
order for it to work for you.

Public Sub Program_setup()
Dim Steps as Integer
Steps = 5
For i=0 to Steps
Start.Progress.Width = (Start.Label2.Width-2) / Steps * i
DoEvents
'place code you want to execute
Next i
Unload Start
End Sub

"Progress" is the name of the raised label and Label2 is name of sunken
label
When the Splash screen form activates, it will call the Program_setup sub
procedure.

Just show the splash screen and everything should work on its own. The
progress bar on this example will whip across very fast. You may not be able
to notice it.

Hope you like the cheap and dirty trick,

Sergio DeAlbuquerque
President

Matrix Technical Services Inc.
172 N.Bicycle Path
Selden, NY 11784

Ph: 631-736-9001
Fax: 631-696-8538

http://www.matrixengg.com
[email protected]
"CAD services, machine design, and VBA application development"
0 Likes
Message 8 of 12

Anonymous
Not applicable


The man is a giant 🙂  VBdesign

Randy wrote:

I should rephrase my question :  I need to display
a progress (or status)

bar to show how much time is remaining in a certain procedure.

Randy <[email protected]> wrote in message

news:[email protected]...

> Is it possible to show a status bar or something similar while a
program

is

> running?  Ideas for either VB6.0 or VBA would be much appreciated.

>

0 Likes
Message 9 of 12

Anonymous
Not applicable
Hi Sergio,
It may be cheap and dirty, but I like it. It could have it's uses when copying mutiple files, ect. It
appears that Randall Rath has come up with a solution as well. Check out the link I posted below. 🙂
-Josh

Sergio DeAlbuquerque wrote:

> Attached you will will a splash screen that I made up completely within
> AutoCAD VBA. No additional references to a status bar control needed. The
> basic idea is to use two labels, one on top of another. Set one labels to be
> sunken and the other to be raises. Change the color of the raised label to
> what you want. I used blue. Then within your procedure, start the width of
> the raised label as 0 and then index the width until completion. Here is
> some sample code to place in your procedure. You'll have to do some work in
> order for it to work for you.
>
> Public Sub Program_setup()
> Dim Steps as Integer
> Steps = 5
> For i=0 to Steps
> Start.Progress.Width = (Start.Label2.Width-2) / Steps * i
> DoEvents
> 'place code you want to execute
> Next i
> Unload Start
> End Sub
>
> "Progress" is the name of the raised label and Label2 is name of sunken
> label
> When the Splash screen form activates, it will call the Program_setup sub
> procedure.
>
> Just show the splash screen and everything should work on its own. The
> progress bar on this example will whip across very fast. You may not be able
> to notice it.
>
> Hope you like the cheap and dirty trick,
>
> Sergio DeAlbuquerque
> President
>
> Matrix Technical Services Inc.
> 172 N.Bicycle Path
> Selden, NY 11784
>
> Ph: 631-736-9001
> Fax: 631-696-8538
>
> http://www.matrixengg.com
> [email protected]
> "CAD services, machine design, and VBA application development"
>
> ------------------------------------------------------------------------
> Name: Splash Screen.frm
> Splash Screen.frm Type: Visual Basic Form File (application/x-unknown-content-type-VisualBasic.Form)
> Encoding: quoted-printable
0 Likes
Message 10 of 12

Anonymous
Not applicable
Thanks for the complement. I checked out Randall's Code. Of course, he
always lives up to his Wonder Liama name.

Liama's Rule!!!!

Sergio DeAlbuquerque
President

Matrix Technical Services Inc.
172 N.Bicycle Path
Selden, NY 11784

Ph: 631-736-9001
Fax: 631-696-8538

http://www.matrixengg.com
[email protected]
"CAD services, machine design, and VBA application development"
0 Likes
Message 11 of 12

Anonymous
Not applicable
er, Sergio, now yer gonna get it. Liama??
-- Walter -- http://www.ActiveDwg.com

Sergio DeAlbuquerque wrote in message
news:[email protected]...
> Thanks for the complement. I checked out Randall's Code. Of course, he
> always lives up to his Wonder Liama name.
>
> Liama's Rule!!!!
>
> Sergio DeAlbuquerque
> President
>
> Matrix Technical Services Inc.
> 172 N.Bicycle Path
> Selden, NY 11784
>
> Ph: 631-736-9001
> Fax: 631-696-8538
>
> http://www.matrixengg.com
> [email protected]
> "CAD services, machine design, and VBA application development"
>
0 Likes
Message 12 of 12

Anonymous
Not applicable
Oops, I meant Llama's Rule!!!! Where did that "i" come from? That's why I'm
not the Wonder Llama.

Sorry Randall.

Sergio DeAlbuquerque
President

Matrix Technical Services Inc.
172 N.Bicycle Path
Selden, NY 11784

Ph: 631-736-9001
Fax: 631-696-8538

http://www.matrixengg.com
[email protected]
"CAD services, machine design, and VBA application development"
0 Likes