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

Hi Andi,

res = InputBox("Enter date")
res = Format(res, "dd-mmm-yy")
MsgBox res

---
Regards,
Norman




"andibevan " wrote in message
...
I need to create a user input form that the user can input a date in the
format 9/7/06 - i.e. dd/mm/yy and this is then copied to a cell in the
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 calculations
on.

Any help on this would be much appreciated

Ta

Andi


---
Message posted from http://www.ExcelForum.com/

Hi andibevan

Maybe you like this
http://www.rondebruin.nl/calendar.htm

with this format
ActiveCell.NumberFormat = "dd/mmm/yy"


--
Regards Ron de Bruin
http://www.rondebruin.nl


"andibevan " wrote in message ...
I need to create a user input form that the user can input a date in the
format 9/7/06 - i.e. dd/mm/yy and this is then copied to a cell in the
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 calculations
on.

Any help on this would be much appreciated

Ta

Andi


---
Message posted from http://www.ExcelForum.com/

Thanks guys - problem now solved :

--
Message posted from http://www.ExcelForum.com