Macro (Pause)

  • Thread starter Thread starter Steved
  • Start date Start date
S

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.
 
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
 
Back
Top