Matt,

You should address the range in Frank's solution via its worksheet, in case
the workbook is ever saved with a different worksheet active, that is

Private Sub Workbook_Open()
Dim input_value
With Worksheets("Sheet1").Range("A1")
If .Value = "" Then
input_value = InputBox("Enter your data")
.Value = input_value
End If
End With
End Sub

Also, I don't know what the Data - Mask that Frank refers to is, might be a
2003 feature or some odd German function <vbg, but you could use the
DataForm functionality.Build a database, column headings, and then you have
built-in form-handling functionality. Better still, use John Walkenbach's
enhanced Data Form addin, available free at
http://j-walk.com/ss/dataform/index.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Frank Kabel" wrote in message
...
Hi
answers see below:

Powlaz wrote:
Is it possible to open a spreadsheet where a pop up comes
up first? Here's what I'm thinking.
Yes, you can use the workbook_open event. Put the following code in
your workbook module (no error checking, etc included - just to give
you an idea):
Private Sub Workbook_Open()
Dim input_value
If Range("A1").Value = "" Then
input_value = InputBox("Enter your data")
Range("A1").Value = input_value
End If
End Sub


Better yet. How can I make a form that the user enters
his start time, lunch in, lunch out, and end time that
will route the times as they are entered to a
spreadsheet. This would effectively have Excel working
as a Database.
If you have created a worksheet with these headings you could use the
inbuild data mask (goto 'Data - Mask'). Maybe this is sufficient for
your requirements

Frank