PDA

View Full Version : Excel VBA Dates



06-09-2000, 06:35 PM
I have a userform with a combobox which uses the 'ListRow' property to provide dates to it-from a named range in the sheet. When using the form the dates are OK when you drop the list down but when you select it displays the numerical format of the date-eg 36775 for today.It self corrects when writing back to the sheet but its annoying and unprofessional. Any help?