Frank,
You are rockin' and rollin' today with my answers. Thank
you VERY much. Got another question about this one. I
may just use the built in Data Mask or (is it Data
Form) but how do I get it to load with the page. I don't
want to have to draw it out of the Data menu. Is that
possible?
I'm going to need to brush up on my
VB code because I
like the idea of using the pop up window but I don't
remember how to assign the data from the input boxes
(Time In, Lunch In, Lunch Out, Time Out) to 4 different
cells.
Aside from that I have the spreadsheet configured so that
if b4:b35 have "H","S","V" in them then c4:f4(down to
c35:f35) shouldn't take input from the user.
It's getting to where the whole workbook ought to be
coded but I've been trying to do as much as I can with
simple Excel tools.
Thanks again for the help,
Matt
PS (check out my Checkboxes post. Any ideas there?)
-----Original 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
.