Macro VBA Code
 

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

Macro VBA Code
 

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

Macro VBA Code
 

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