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.

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.

Patrick,

Thanks. Not quite what I had in mind. Wanted a message box to appear into
which I'd input my text. On clicking "OK" this would then be written to the
cell (B2). I'd then be given another message box into which I'd input the
date. This would then be entered into cell E2 when "OK" clicked.


"Patrick Molloy" wrote:

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.

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)


"barrowhill" wrote in message
...
Patrick,

Thanks. Not quite what I had in mind. Wanted a message box to appear
into
which I'd input my text. On clicking "OK" this would then be written to
the
cell (B2). I'd then be given another message box into which I'd input
the
date. This would then be entered into cell E2 when "OK" clicked.


"Patrick Molloy" wrote:

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.

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.

A short-cut for this procedure (assuming you are *not* using XL2007) is to
right-click the XL icon immediately to the left of the File menu item and
select View Code... the VB editor will open up and you will be placed
directly inside the code window for ThisWorkbook.

--
Rick (MVP - Excel)

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.

Sorry, I posted this to your message by mistake.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
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.

Rickm

Should of said I was using Excel 2003.

In answer to your question, No and Yes !. I've added the main code line
with obviously changed parameters to and existing procedure.

On opening I don't get the input box requesting my text/date. Hence Answer
No.

If I run in debug mode and run to curser where curser is set after 'End Sub'
it works. Hence answer Yes.

Perplexed!?!

"Rick Rothstein" wrote:

Sorry, I posted this to your message by mistake.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
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.

Do you perhaps have your security settings set to not run macros?

--
Rick (MVP - Excel)


"barrowhill" wrote in message
...
Rickm

Should of said I was using Excel 2003.

In answer to your question, No and Yes !. I've added the main code line
with obviously changed parameters to and existing procedure.

On opening I don't get the input box requesting my text/date. Hence
Answer
No.

If I run in debug mode and run to curser where curser is set after 'End
Sub'
it works. Hence answer Yes.

Perplexed!?!

"Rick Rothstein" wrote:

Sorry, I posted this to your message by mistake.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
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.