Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formated date thru Input box
hi all,
how can i get a user input a date and get it in my Cell C8 formated in dd/mm/yyy ? something like: Newdate = inputbox("Enter New Date: ", Date) and this will be my date in C8? TIA Soniya |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formated date thru Input box
Newdate = inputbox("Enter New Date: ", Date)
if isdate(newDate) then With Worksheets("Sheet1") .Range("C8").Value = cDate(newDate) .Range("C8").NumberFormat = "dd/mm/yyyy" End With End if -- Regards, Tom Ogilvy "Soniya" wrote in message ... hi all, how can i get a user input a date and get it in my Cell C8 formated in dd/mm/yyy ? something like: Newdate = inputbox("Enter New Date: ", Date) and this will be my date in C8? TIA Soniya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date formated as date showing as number | Excel Discussion (Misc queries) | |||
changing dates in a date formated column ? | Excel Discussion (Misc queries) | |||
How do I add 24 hours to a date and time value formated cell? | Excel Discussion (Misc queries) | |||
fields formated as 3-8-18 autoformatting to date on when exported | Excel Discussion (Misc queries) | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) |