In it's simplest form ...

Sub AskUser()

Range("A1").Value = InputBox("Please input month number for report")

End Sub


PaulB wrote:
In the old days I used to use \0 macros and {GETNUMBER} or {GETLABEL} in
Lotus to get a number from a user having asked a question like "Please input
Month number for report" and it would put a number into a cell to drive
indexes and Vlookup and hlookup tables.

Any one have any ideas on how to do this in VBA please - this is a dark
street for me!

Thanks

Paul