Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date in an excel form
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date in an excel form
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date in an excel form
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date in an excel form
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date in an excel form
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! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date in an excel form
Okay, let's say that the Sun date is in A1. In the Mon date cell, input the
formula =A1+1. In the Tue date cell, input the formula =cell+1 where cell is the Mon date cell. etc. -- HTH RP (remove nothere from the email address if mailing direct) "Sarah" wrote in message ... 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! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date in an excel form
woweeeeeeeeee you're a genius! :)
thanks!! :D "Bob Phillips" wrote: Okay, let's say that the Sun date is in A1. In the Mon date cell, input the formula =A1+1. In the Tue date cell, input the formula =cell+1 where cell is the Mon date cell. etc. -- HTH RP (remove nothere from the email address if mailing direct) "Sarah" wrote in message ... 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! |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date in an excel form
No, just slow to understand :-)
Bob "Sarah" wrote in message ... woweeeeeeeeee you're a genius! :) thanks!! :D "Bob Phillips" wrote: Okay, let's say that the Sun date is in A1. In the Mon date cell, input the formula =A1+1. In the Tue date cell, input the formula =cell+1 where cell is the Mon date cell. etc. -- HTH RP (remove nothere from the email address if mailing direct) "Sarah" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
How do you convert an uncoded date (e.g., 20080304) to a date form | Excel Worksheet Functions | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
DATE IN TEXT FORM - NEED TO CHANGE IT DATE FORM | New Users to Excel | |||
how to generate a unique form # when using an excel form template | Excel Worksheet Functions |