| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format and Form
I have a form that on load take a date (dd-mm-yy)) from a cell
(TextBoxDate.Value = ActiveCell.Offset(0,3).Value) and put it in a TextBox. If i change the date in the form and update the original cell (ActiveCell.Offset(0,3).Value = TextBoxDate.Text) i loose the cell's format and the pivot table related to it stop to work. Any ideas? Thanks, Andrea. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date format and Form
try...
(ActiveCell.Offset(0,3).Value = Format(ActiveCell.Offset(0,3).Value), "dd-mm-yy")) HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "news.libero.it" wrote: I have a form that on load take a date (dd-mm-yy)) from a cell (TextBoxDate.Value = ActiveCell.Offset(0,3).Value) and put it in a TextBox. If i change the date in the form and update the original cell (ActiveCell.Offset(0,3).Value = TextBoxDate.Text) i loose the cell's format and the pivot table related to it stop to work. Any ideas? Thanks, Andrea. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date format changes when inputed from user form | Excel Discussion (Misc queries) | |||
| Date format problem from form to sheet | Excel Discussion (Misc queries) | |||
| visual basic user form date format dd/mm/yy not mm/dd/yy | Excel Discussion (Misc queries) | |||
| Date Format on Form | Excel Programming | |||
| how to format a date/validate for a text box entry on a user form | Excel Programming | |||
Linear Mode
