Combo Box & Date - Please Help

[Tracey_D]

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

[royUK]

What are you doing with the dates?

Please Login or Register  to view this content.

[Tracey_D]

The user will select a date and a sheet is copied and renamed as the date which the user selected.

However the main problem is when the user selects the date, the combo box then displays it as a string and looks unprofessional

Sorry but I don't understand that code which you wrote as wont that display a message box?

[Tracey_D]

Anybody else know how to help

[royUK]

The messagebox was to demonstrate the results, the actual code needs implementing into your existing code. I can't do that because I haven't any idea what you are doing!

I wouldn't work with individual sheets per date, it's just not an efficient way to deal with data