About Us

Muhammed Rafeek M

Sriram,
send me your code, i do update and will send you imm.

"Sriram" wrote:

Yep I inserted a progress bar and now the time taken by the script is less
and it is working faster than earlier. i can't see the progressbar updating
and running from 0-10000.

Kindly tell me what to do.

Sriram

"Muhammed Rafeek M" wrote:

Yes you have to insert Progressbar to your worksheet: if you need more, mail
me:

"Sriram" wrote:

But you mean Mr. Md.

As you mentioned, in your code 'ProgressBar1', whether I've to keep a
progress bar with a name like this. or a simple code.

Pleas clear me to proceed further. I want to implement right now itself.

Thanks & Regards,
Sriram

"Muhammed Rafeek M" wrote:

see one sample progress bar without using UserForm:

Private Sub Worksheet_Activate()
ProgressBar1.Visible = False
End Sub
Sub ShowProgressBar()
Dim i As Variant
ProgressBar1.Visible = True
ProgressBar1.Min = 0
ProgressBar1.Max = 10000
ProgressBar1.Top = 150
ProgressBar1.Left = 250
For i = 0 To 10000
ProgressBar1.Value = i
'write ur programm
Next i
ProgressBar1.Visible = False
End Sub

Note: Inser progressbar to your worksheet and copy above command and paste
to Sheet Module.

"Sriram" wrote:

Dear Friends,

I want to find out and capture the event's progress in a Progress Bar in
excel macro.

Example, in my project when a sheet is activated, there will some area where
the user can enter their data and the rest will be locked and hidden.

For example, the user can enter the data starting from Column 'A' till
Colimn 'AZ'. So I've written a code to hide the columns from BA till end.
While this process is running excel is busy and we can't do anything. This
process is running for around 2-3 seconds only.

But my wish is that, if this process is running, then a progress bar should
be shown, whose starting value and ending value should be in line with the
hiding event process's value. So that when the excel starts hiding the Column
'BA', the progress bar should start from 0 (zero) and will progress along
with the event's process and should End, when all the mentioned columns are
Hidden by the code.

This I want to implement for all sort of background process the code does
with my excel sheet or book.

Kindly help me out to achieve this.

Thanks,
Sriram

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Progress Bar	leerem	Excel Discussion (Misc queries)	2	August 13th 08 05:16 PM
Progress Bar	PAL	Excel Worksheet Functions	3	August 13th 08 03:28 PM
progress bar	[email protected]	Excel Programming	5	January 19th 05 01:58 PM
Progress Bar	dcronje	Excel Programming	0	September 30th 04 04:32 PM
Progress Bar	Karen[_12_]	Excel Programming	0	June 14th 04 06:42 PM

Menu

About Us