Hi Paul,
when you go to the discussion groups you have a window to enter the words to
be search, beside there is another window where you can choose from different
groups, let' say excel, new users, and excel programing. If you don't see
this windows go to the news group and just search for Progress Bar, I did and
you will find like 30 different answers, I wanted you to go there so you can
decide which one works better for you

hope this helps now

"Paul W Smith" wrote:

With respect, what sort of answer/assistance is that?

I had hoped I had formulated my question respectfully enough to be taken
seriously. Yes there are alternatives that the people who wrote my
requirement, for reasons of their own, did not wish to use. I was asked if
a progress bar could be used on a worksheet. I tried and could not
reference it, so thought someone more knowledgable than I might offer some
sage advice.

So to ask again, is it possible to control a Microsoft ProgressBar Control
version 6.0, placed on a worksheet, from within running VBA code - if so how
is the control referenced?

Paul Smith



"Bob Phillips" wrote in message
...
Yeah, it is really dumb to do something that is easy isn't it?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Paul W Smith" wrote in message
...
Is it possible to use a progress bar on a worksheet?

I have added the to my Controls list in Excel 2007. I can insert the
control onto my worksheet but I can find no way of controling it, or
referencing it for that matter.

I am not interested in using the control bar on a userform, that would be
too easy and not waht my deliverable requires!

Paul Smith






.