Repeating macro

[Douglas]

I am trying to learn how to write macros in Word 2007, and I need to develop
a macro that will repeat a certain task a specified number of times. To
initialize the macro, the user will enter in the number of times the task
will be repeated, so the macro will keep performing the job until the
specified limit has been reached.

 

[Helmut Weber]

Hi Douglas,

;-)

Sub Test6666()
Dim l As Long
On Error GoTo theend
For l = 1 To InputBox("howoften")
MsgBox l 'or your macro
Next
Exit Sub
theend:
MsgBox "damn it"
End Sub





--

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Vista Small Business, Office XP

 

[Douglas]

Thanks for the help. But now I need to figure out how to create a userform
where I can input the number of times I want the macro to repeat.

 

[David Sisson]

Thanks for the help.  But now I need to figure out how to create a userform
where I can input the number of times I want the macro to repeat.

We understand you want the macro to repeat, but without more detail,
we can only offer 'best guess' advice.

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

 

[tedmi]

You don't need to create a userform - the InputBox command does that for you.