Writing Code

[sk]

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!

 

[Bernie Deitrick]

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

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?