Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Formatting Within A Combo Box On A Userform
Hi All,
Using Excel 2007 I have a combo box with a row source of dates linked to a column of worksheet cells. The cells on the worksheet are UK formatted as dd/mm/yy and appear as such. The form opens and when a user clicks on the combo box the dates can be viewed correctly - so far so good. The problem I need help with is when the user (me) selects a date from the list it appears as a date serial number and not in the anticipated format. Any help with this would be greatly appreciated. Regards - Div |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Userform | Excel Programming | |||
~~ Help with Userform and Combo Box ~~ | Excel Programming | |||
Userform Date Formatting MM/DD/YYYY | Excel Programming | |||
UserForm text box Date formatting | Excel Programming | |||
Combo Box in userform | Excel Programming |