Macro VBA Code

V

Val Steed

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

Paul B

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 **
 
H

Harald Staff

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

HTH. Best wishes Harald
 
Top