elgringo56
Well-known Member
- Joined
- Apr 15, 2002
- Messages
- 869
I have to be the dumbest guy in the world. Here goes. I have a combo box. The Target cell for the box is Y1. It is formated as Date style 03-Apr-02. The list range for the combox is set to Y48:Y79. Each of these cells contain the formula =TODAY(), =TODAY()-1, etc. The cells are formated as Date style 03-Apr-02 also. Now, when I click the arrow on the drop down box, I see this list. Thats kewl. Now, I select an entry in the list. Here is where I am stuck. The list goes away as it should, but in the combo box appears one of those goofy date numbers that Bill Gates programmers are so fond of. The Target cell also goes to that goofy number. I want the actual date to appear in the target cell and the combox. Any way I can do this? I cant seem to find a format for this?