I have put a combo button on a form 1

[laurafinn]

I have put a combo button on a form which I am trying to use to look up a data from a worksheet. So I have a column called colDate which contains all the dates and I link this to the Combo button. When I use the combo button to select a date, the date shown in the combo button turns out to be a number and not the date - almost as if the combo button has been formatted to only accept number s i.e it has converted the date selected into a number. Please can any one help

L

 

[MadForIt]

Hi Laurafinn,

I had the same problem. As you say the dates in the drop down appear okay, but the one you select changes to a number. The only way i got it to work was to precede the dates on the worksheet with an apostrophe '.

Rgds MadForIt