Forum Home
Press F1
 
Thread ID: 5643 2000-09-06 07:35:00 Excel VBA Dates Guest (0) Press F1
Post ID Timestamp Content User
6226 2000-09-06 07:35:00 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? Guest (0)
1