View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default For Robin Hammond

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
=---