LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 34
Default Displaying a Progress Indicator (VBA)

Does anyone know how to use the Percentage Indicator bar VBA? I found it on
this website http://j-walk.com/ss/excel/tips/tip34.htm and I think it
is really cool. Unfortunately the code is only written specifically for the
purpose of creating random numbers to fill up 25 columns and 100 rows.
Sometimes I come across lengthy macros and wonder if my computer "hung up" on
me.
Look at my simple macro for bold, red and underline
Sub Macro1()
Range("E8:E9").Select
Selection.Font.Bold = True
Selection.Font.ColorIndex = 3
Selection.Font.Italic = True
Selection.Font.Underline = xlUnderlineStyleSingle
Range("I5").Select
End Sub

How do I create a progress bar for this code. I tried but only produced a
"frozen" Progress Indicator bar. I am using windows 2003
Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Progress bar [email protected] Excel Discussion (Misc queries) 1 January 6th 07 01:49 PM
Progress Moons Daigle Excel Discussion (Misc queries) 1 August 28th 06 10:41 PM
Progress Tax Calculator Matt Excel Worksheet Functions 12 June 26th 06 12:17 PM
Progress bar doesn't appear when saving khw Excel Discussion (Misc queries) 1 November 7th 05 02:08 PM
Progress YTD Lance Charts and Charting in Excel 1 March 29th 05 07:16 PM


All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"