-2

I looked around the web for various Progress Bar tutorials, but could not find one that would help me. I am trying to create a UserForm Progress Bar that will pop up when I click "Yes" on a MsgBox.

The progress bar itself should then display the progress of the subs. The problem is, I have a lot of subs that activate after each click of a button, around 10. Those subs themselves, respectively, have a couple of subs in them each.

Displaying a completion % value is not important to me - instead, I would prefer that the progress bar show me names of Subs which are currently running. Would that be possible somehow? Thank you!

Our Man in Bananas
  • 5,687
  • 20
  • 88
  • 144
Faraj
  • 17
  • 5
  • 1
    Please show us what you have tried...and to get you started look at [SO: How to get the procedure or function name at runtime?](https://stackoverflow.com/questions/23945321/how-to-get-the-procedure-or-function-name-at-runtime) and [Progress bar in VBA Excel](https://stackoverflow.com/questions/5181164/progress-bar-in-vba-excel/5181347) and [MS KB: (J Walkenbach - How to display a progress bar with a userform in Excel](https://support.microsoft.com/en-gb/help/211736/how-to-display-a-progress-bar-with-a-user-form-in-excel) – Our Man in Bananas Nov 21 '18 at 08:34
  • But what you want may not be possible - [look here (Chip Pearson)](http://www.cpearson.com/excel/InsertProcedureNames.aspx) – Our Man in Bananas Nov 21 '18 at 08:41
  • Hi @OurManinBananas! Thanks for your reply. Apologies for not including any code - I am new to VBA (4 days of experience), so I was not able to produce any working code myself that could visually explain my problem. Right now my question is mainly whether that is even possible, hypothetically, but based on the links you sent it seems extremely complicated. I will try to implement David G's suggestion and see if it works. Thank you for your help! If you wish, you can delete this question - I have saved your links. – Faraj Nov 21 '18 at 09:30

1 Answers1

-1

Create a field in your form, each sub updates that field with the desired text/number.

David G
  • 917
  • 1
  • 11
  • 20