Тёмный

Progress bar - watch your macro performance - Simple Excel VBA 

SimpleExcelVBA
Подписаться 2,3 тыс.
Просмотров 2,4 тыс.
50% 1

Starting to code in VBA always wanted to see that loading rectangle as a progress bar to watch the working macro, for instance like in every software or game installation. Not only for fancy issue, but mainly to know in which point of macro I am.
simpleexcelvba.com/progress-b...
Please like and subscribe my channel, it means a lot for me :)
Website: simpleexcelvba.com/
Facebook: / simpleexcelvba
Pinterest: / simpleexcelvba

Наука

Опубликовано:

 

3 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 9   
@rafab.4413
@rafab.4413 4 года назад
I am using similar solution but instead of module I think better idea is to store the code in form's code. Form is just a simple class, the only difference is that the form is class with GUI. The benefit is that you can export your userform only and import to use in another project instead of exporting userform an module together. For me it is also more comfortable to use progressBar as a class, because you can implement more methods to use it comfortable in a code (adding percentage "steps" in code in a few different ways and intellisense will help with code e.g. .setStageName for short description what we are doing at the moment). Pozdrawiam
@SimpleExcelVBA
@SimpleExcelVBA 4 года назад
And this is the beauty of programming, there is no only one solution.
@tonnievaneldik9183
@tonnievaneldik9183 3 года назад
Hi there i type everything over and start the macro but it didn't work. the form appears and nothing happens. when i close the form in the right corner (X) then the 10.000 ones will be printing in colum 1. do i anything wrong, please could you help me a bit of that. Regards Tonnie
@SimpleExcelVBA
@SimpleExcelVBA 3 года назад
Did You create the progress bar form and typed the code refreshing the progress bar in module? Please message me with the screenshot of your VBE and I'll try to figure out what is wrong :)
@tonnievaneldik9183
@tonnievaneldik9183 3 года назад
Hello again I solved the problem and it works fine now.
@SimpleExcelVBA
@SimpleExcelVBA 3 года назад
​@@tonnievaneldik9183 What was the problem? Just curious :)
@tonnievaneldik9183
@tonnievaneldik9183 3 года назад
@@SimpleExcelVBA Progression.Show (False)
@medfdgdfg
@medfdgdfg 2 года назад
slabo sie tego slucha z tym lamanym angielskim
@SimpleExcelVBA
@SimpleExcelVBA 2 года назад
Nobody is perfect! ;)
Далее
10X Your Excel with Macros & Basic VBA
11:18
Просмотров 76 тыс.
Лайфхак с колой не рабочий
00:16
Просмотров 215 тыс.
🤘РОК или ПОП?💖
3:20:26
Просмотров 1,7 млн
Excel VBA Forms Part 20 - Progress Bars
22:39
Просмотров 27 тыс.
Ultimate Progress Bar Control in VBA Userform
12:40
Просмотров 38 тыс.
Excel VBA  - Cell Referencing
8:33
Просмотров 598 тыс.
Progress Bar Control on a Userform using Excel VBA
9:27
Excel VBA Progress Bar on Userform
20:01
Просмотров 72 тыс.
How to Create  Progress Bar in Excel with VBA
6:13
Просмотров 15 тыс.
3 Simple Tips for Looping Cells in VBA for Excel
8:02
VBA Tutorial (Chap 7): Recursion (1 of 2)
7:37
Просмотров 3,7 тыс.