Just ask for it:

Sub FillMeIn()
x = Application.InputBox(Prompt:="give me some data", Type:=2)
End Sub
--
Gary''s Student - gsnu200840


"Frank" wrote:

How can I write a macro that needs to wait for a user to input information
and then continue to finish the macro action