How do I use an input box to run a simple macro multiple times? I want the user to be able to enter a number after a button is clicked and then the macro will run that many times.
My macro calls 4 other macros that all need to be run so it's pretty simple.
Please Login or Register to view this content.
Check this out
http://www.excelforum.com/excel-gene...-of-times.html
~~LaffyAffy13~~
If I have helped you solve your problem, please be sure to clickat the bottom left of my post.
Thanks.
Thanks for the response! I know how to run a macro multiple times, I just have no experience with input boxes and calling their inputs. Would
I don't know how to test for bad inputs either. If they put in anything that is not an integer then it won't work.Please Login or Register to view this content.
Nevermind, it does that on its own!
Haha no way, I just found the exact same thing and edited it on my own.
When I run mine, if anything other than an integer is entered, i get an error "The number is not valid" and if its a decimal, it rounds to the nearest whole number. What is your current issue?Please Login or Register to view this content.
I'm not having any errors, I thought I would! I'm used to programming in C where you have to create and account for all those errors haha thanks for your help
Oh cool. Glad I could help
If I want it to display an error if the number entered is larger than 20 how would I manage that?
That gives me an error for any number entered...Please Login or Register to view this content.
Nevermind, TypeName(x) hadn't saved as TypeName(response). It works now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks