Hi
I am trying to populate a combo box from cells in a sheet which contain dates - Not a problem - Using the rowsource property on the combo box.
However when I click on a date from the combo box it returns the value as a string.
I have searched the net and found various code snipits but none seem to work - Some return the date to a random date in 2007 and others minus 1 from the actual date.
The date format has to be DD-MM-YY.
Ideally i would like it displayed as 01-sep-11 but i can settle for 01/09/11 at this point
Thanks
Tracey
Bookmarks