Could someone give me the inputbox command that would pause for input and
place the results in cell b3

Val, try this

Sub test()
MyData = InputBox("Your Message Here", "Title Here")
If MyData = "" Then

Exit Sub
End If
Range("A1").Value = MyData

End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"Val Steed" wrote in message
...
Could someone give me the inputbox command that would pause for input and
place the results in cell b3

Sub test()
Range("B3").Value = InputBox("Anything man:")
End Sub

HTH. Best wishes Harald

"Val Steed" skrev i melding
...
Could someone give me the inputbox command that would pause for input and
place the results in cell b3