Thanks for the note, I'll try it.

As for the Red - Blue challenge I'm sure someone will be tweaking code as we
speak!

Cheers
Nigel

"Robin Hammond" wrote in message
...
Nigel,

there's a newer version up on the site. I even tweaked it so that the
colour
of the bar starts off red and gets progressively more blue as you move
further across to get away from local machine colour settings
(unfortunately
for the whole bar, but if anyone can tweak this to be red at the start and
blue at the end I'd be intrigued).

http://www.enhanceddatasystems.com/E...rogressBar.htm

Robin Hammond
www.enhanceddatasystems.com

"Robin Hammond" wrote in message
...

Nigel,

thanks for the feedback. Funnily enough I have been meaning to fix that
cursor thing for months now but there has always been something more
interesting.

Simply set the enabled property for the two controls on the form
txtProgFore
and txtProgBack to false, and it goes away.

You can also tweak the values for top and height of txtProgFore to get a
slightly more 3d effect, which is I think what you are suggesting. Top
at
79
and height of 17 might look slightly better. Guess I better change the
published version.

Finally, on my machine the progress bar is light blue, matching the
inactive
title bar colour setting on windows. You can change the txtProgFore
Backcolor setting to change this.

Yours,

Robin Hammond
www.enhanceddatasystems.com

"Nigel" wrote in message
...
Hi Robin,
I picked up you reference to the progress bar class module you have
developed and downloaded it for review. More interest than for a
specific
application.

From a educational perspective it shows a lot of the challenges of
setting
up class modules so I was pleased to discover these.

In terms of the actual module, in my version of Excel (10 SP-2) the
progress
form textbox shows a flashing edit cursor, which remains at the left
of
the
text box, whilst a pale grey vertical line progresses through the box
(L
to
R) as the demo runs. Is this correct?

It seems to me that no cursor would be better and a more positive
progress
bar would be a bar extending inside the textbox from L to R.

I'm probably missing something.

Cheers
Nigel





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World!
100,000
Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via
Encryption
=---








----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---