| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting a TextField as DD-MMM-YY format
just for completeness, there is a typo.
EndDte.txt = Format(Date + clng(Duration),"dd-mmm-yy") should be EndDte.text = Format(Date + clng(Duration),"dd-mmm-yy") -- Regards, Tom Ogilvy Mike NG wrote in message ... On Sun, 14 Sep 2003 at 10:12:37, Tom Ogilvy (Tom Ogilvy ) wrote: If IsNumeric(Duration) Then EndDte.txt = Format(Date + clng(Duration),"dd-mmm-yy") End If Many thanks - worked a treat -- Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I conditionally format a row and copy the formatting to tab | Excel Worksheet Functions | |||
| Using Format Painter with Conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting - Number Format | Excel Worksheet Functions | |||
| Using Excel as a database and textfield | Excel Discussion (Misc queries) | |||
| Can I get rid of conditional formatting but keep format changes? | Excel Discussion (Misc queries) | |||
Threaded Mode
