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

  • Thread starter Thread starter ian123
  • Start date Start date
I

ian123

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
 
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
 
Back
Top