Solomon, try something like this

Range("A1").Value = "x " & InputBox("Enter Your 3 digit number", _
"Enter Number")

--
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 2002 & 2003

"solomon_monkey" wrote in message
ups.com...
Morning,

I would very much like a dialogue box to pop up and prompt the user to
insert a three digit number so as to populate cell A1 and the Worksheet
with the letter 'X' and the three digit code entered.
Any easy ideas?

Thanks

Solomon