VBA - Run code while another is in process - Microsoft Community

hello everyone,

i've got userform has "please wait while workbook being set up..." label in it. want label update 1 period (.) 3 (...)  while code running in background.

the document i'm trying set big, , considering fact computers it's being used on can slow i've had reduce speed of macro being executed in order release pressure system. in mind want visual aid demo users happening in background need wait on.

any ideas how can have label caption update accordingly while said code processing? thought "do while" trick but, unless i've got set wrong, it's not doing anything.

cheers,

daniel

need loop somewhere in code. either wrapping whole snippet or part of processing. within loop, want update label or textbox on form. like:

me.labelname.caption = me.labelname.caption & "."  me.repaint

repaint redraw form.

might search [i] vba progress bar[/i] other examples of visual indication of continued processing.

Office / Excel / Microsoft Office Programming / Office 2016