ooooooops sorry ..

I'm just using a spreadsheet, the date is just being entered into an excel
CELL and so, the user will enter the first date for the sunday of the week,
and then i want it to automatically fill in the dates for the rest of the
week (mon-sat)

please help! :) thank you! :)

"Bob Phillips" wrote:

Sarah,

You said it was in a form, so I took some licence and assumed that you would
have the dates in textboxes. Re-reading your post, I don't think you
actually mean a form, so where will you store these dates, and how will the
series be started.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sarah" wrote in message
...
I am trying this, I'm not sure where I'm supposed to put this line of code
in

I put it in the workbook_open

Private Sub Workbook_Open()
Sheet1.TextBox2.Text = Format((CDate(TextBox1.Text) + 1), "dd mm yyyy")
End Sub

but I'm getting an error!
Help!?!!!

"Bob Phillips" wrote:

Start with

Textbox2.Text = Format(cdate(TextBox1.Tex)t + 1, "dd mmm yyyy")
etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sarah" wrote in message
...
Hi,

I'm creating a chart in an excel form and it has the same section 7
times
(for every day of the week)

I want it so that once the user enters the first date for Sunday. eg
they
enter: 12/12/04, then all the other date fields for the rest of the
week
get
filled in automatically. So the date field for that Monday will be
12/13/04...

Is this possible?!?! If yes, how!