Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass date to cell in spreadsheet
The following code Code: -------------------- CellPosition.Value = frmWorkHistory.txtStartMonth.Value) & "/31/" & frmWorkHistory.txtStartYear.Value -------------------- passes the value in text boxes txtStartMonth and StartYear to a cell in my spreadsheet I thought since the cell is formatted as date that the value in CellPosition.Value would display as a date but it's not can I use DateValue?? how can I pass a date to the cell in the spread sheet? Code: -------------------- Function StartDate() counter = 1 Set CellPosition = Range("C13") Do While counter <= 10 If CellPosition.Value = "" Then CellPosition.Value = frmWorkHistory.txtStartMonth.Value) & "/31/" & frmWorkHistory.txtStartYear.Value MsgBox CellPosition.Value Exit Do Else Set CellPosition = CellPosition.Offset(1, 0) counter = counter + 1 End If Loop End Function -------------------- -- cedtech23 ------------------------------------------------------------------------ cedtech23's Profile: http://www.excelforum.com/member.php...o&userid=31022 View this thread: http://www.excelforum.com/showthread...hreadid=507527 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I pass network logon name to a cell in a spreadsheet? | Excel Worksheet Functions | |||
How to calculate pass/fail percentages entered on a spreadsheet? | New Users to Excel | |||
How do I flag a cell in Excel 2002 when the date entered has pass | Excel Discussion (Misc queries) | |||
How do I flag a cell in Excel 2002 when the date entered has pass | Excel Discussion (Misc queries) | |||
Pass file name from Spreadsheet Range | Excel Programming |