Ok I'll try to use an inputbox. I work better with examples do you think you
could give me a small example of using an input box when an excel sheet is
opened? Thanks

"Chip Pearson" wrote:

The easiest way is to use an InputBox.

Dim S As String
S = InputBox("Enter Something")
Range("A1").Value = S


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Larry Sartoris" <Larry wrote
in message
...
I'm trying to make a pop up and then have the user enter data
into the pop
up. Then use that data to make calculations in the excel
sheet. Too
complicated for excel?

Let me know if I confused you at all

Thanks for any help.