Writing Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a novice at writing code so I need help. I am trying to create an input box to pop up in an excel form and have the information that was put in the box to drop into a particular cell?

Help!
 
sk,

You could use something like this:

Range("A1").Value = InputBox("Enter your name.")

If you want to validate the entry, you can use:

Range("A1").Value = Application.InputBox("Enter your name.", , , , , , , 2)

which makes Excel validate that the user enters a string.

HTH,
Bernie
MS Excel MVP

sk said:
I am a novice at writing code so I need help. I am trying to create an
Click to expand...
input box to pop up in an excel form and have the information that was put
in the box to drop into a particular cell?
 
Back
Top