Hi!
I have a macro that launches after a button is pressed. After the macro runs the relevant data is populated into a small range of cells. Right now it just kinda pops up after the macro runs.
I wanted to see if I can write a macro that continually generates a random number in the first cell while the macro is loading (almost like a macro loading screen). Then, I'd like to have the numbers populate one at a time through the range like a waterfall. I was thinking I could write a line in VBA to pause the macro for a very short period of time before the next number is generated but was hoping for suggestions on how to do this. Any thoughts are greatly appreciated? Thanks!
I have a macro that launches after a button is pressed. After the macro runs the relevant data is populated into a small range of cells. Right now it just kinda pops up after the macro runs.
I wanted to see if I can write a macro that continually generates a random number in the first cell while the macro is loading (almost like a macro loading screen). Then, I'd like to have the numbers populate one at a time through the range like a waterfall. I was thinking I could write a line in VBA to pause the macro for a very short period of time before the next number is generated but was hoping for suggestions on how to do this. Any thoughts are greatly appreciated? Thanks!
