Thread: Pop Up Window
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Pop Up Window

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