Macro (Pause)

[Steved]

Hello from Steve Dee

I would like to run a macro, pause it to enter data then
allow the macro to run again.

Please how do I do this

Thankyou.

 

[Gord Dibben]

Steved

Use the InputBox to pause and collect the data for use

Public Sub who_is_it()
Dim somename as String
somename = InputBox("Enter your name")
MsgBox "your name is " & somename ''message pops up with name
Range("A1").value = somename ''name is placed in A1
End Sub

Gord Dibben Excel MVP XL2002

 

[Steved]

Thankyou