Looping Macro using an input fro the user

[snipescc]

Hello Excel people!

I'm making a promotional document for my company. It uses a combination of RandBetween and conditional formatting to make lights change color on a Christmas Tree, flames flicker on a Menorah ect. Right now I have a macro that will rerun all the calculations once a second for about a minute. I'd like to change it so the person pressing the button can tell the macro how many minutes they would like it to run. My thought is someone putting it up as a background while they were doing something else. Can anyone tell me the code to create the ialog box, get a input, and loop the macro that many times?

 

[Joe4]

Take a look here: http://www.excel-easy.com/vba/examples/inputbox-function.html

How to incorporate the looping may depend on how you have your code currently written. So if you need help with that part, please post your code.