Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox as Date
I need to create a user input form that the user can input a date in th
format 9/7/06 - i.e. dd/mm/yy and this is then copied to a cell in th worksheet in the format = 09-Jul-04 I am stuck as I can only copy the text in the same format as inputted i.e. it is chown as 9/7/06 which you can not perform date calculation on. Any help on this would be much appreciated Ta And -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
InputBox | Excel Discussion (Misc queries) | |||
Inputbox with VBA | Excel Discussion (Misc queries) | |||
Date from InputBox | Excel Programming | |||
InputBox | Excel Programming | |||
inputbox | Excel Programming |