User enters data in popup box - its entered into desired cell
 

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/

User enters data in popup box - its entered into desired cell
 

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/