ian123,
You could search Google for plenty of different ways
to do this.
Here's a siple one:
range("B7").Value = inputbox("Enter your Name")
John
"ian123" wrote in message
...
Can anyone help with a simple macro that will bring up a input box
allowing the user to enter their name which will then, on clicking OK,
enter their response into a predetermined cell, say B7.
Simple? Not for me! Please help
---
Message posted from http://www.ExcelForum.com/