Results 1 to 2 of 2

Thread: Need help to create a Progress bar with VB6

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2000
    Location
    California
    Posts
    1

    Post

    I have an application that call several macros in excel and word and I don't know how to create a progress bar that display the progress of my aplication when is running these macros. Can somebody help me with this.
    Thanks.

  2. #2
    Hyperactive Member mikef's Avatar
    Join Date
    Jun 2000
    Location
    Beach bound...
    Posts
    510
    Put a progress bar on your form, set the max value in the properties window and update it before or after each call you make. example like so:

    RunMacro_Click()

    ProgressBar1.value = 5

    'Run your Macro'

    'Update Progress Bar after completion

    ProgressBar1.value = 15

    'Run next macro'

    ProgressBar1.value = 25

    etc.
    etc.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width