If you name a macro Auto_Open, it will automatically execute when
the sheet is opened. E.g.,

Sub Auto_Open()
Dim S As String
S = InputBox("Enter Something")
If StrPtr(S) < 0 Then
Range("A1").Value = S
Else
' user clicked cancel
End If
End Sub



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


"Larry Sartoris" <Larry wrote
in message
...
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.