PDA

View Full Version : Solved: Run a macro with inputbox



slamet Harto
04-01-2010, 02:58 AM
Hi there

Can you help me on how to call a macro with inputbox

Let say, when user put "20" in inputbox, then macro will run 20 times.

thanks in advance,
best, harto

Bob Phillips
04-01-2010, 03:37 AM
x InputBox("How many times?")

If IsNumeric(x) Then

For i = 1 To x

Call myMacro
Next i
End If

slamet Harto
04-01-2010, 03:52 AM
Thank you so much, Bob.
Highly appreciated it.

Have a great day