Except for the the cell being assigned to (you didn't tells us that in your
first posting, but you should be able to change that on your own) and the
fact that only one question was asked (you should be able to add the second
question easy enough by just duplication the first one), what about
Patrick's solution didn't work for you?

--
Rick (MVP - Excel)


"Patrick Molloy" wrote in message
...
in the development environment (ALT+F11)
from the Project Explorer, right click the ThisWorkbook object and select
View Code
- in fact double clicking it opens its code window.
select 'Workbook' in th eobject list
Excel adds the _Open event

add the code and edit it appropriately


Private Sub Workbook_Open()
Worksheets("Sheet2").Range("A1") = InputBox("Please enter the date")
End Sub

"barrowhill" wrote:

I have a spreadsheet that on opening for first time requires the input of
text (a venue) in one cell and the Date in another.

On opening, I'd like to be prompted to input the venue then prompted to
input the date.

Appreciate help.