Using an input box to run a macro a defined number of times

Описание: In this video we outline how you can create a macro that will run as many times as you define by entering a number into an imput box that will prompt you when it runs.

If you are new to Excel macros then please follow this quick playlist to ensure you are able to follow along with this tutorial.

The code that we used in the video is as follows.

Dim runmacro
runmacro = Application.InputBox("How many times would you like this macro to run?", "Enter a number", , , , , , 1)

If IsNumeric(numrow) Then

For i = 1 To runmacro

Call example

Next i
End If

Remember you may need to change the "macroname" part of this code to the name of the macro you created , otherwise it will not call it correctly.

If you have any questions or comments then please put these in the description below.

Thank you for liking and subscribing to the channel.