Combo box displays positions not date
 

Hi, I have a list of dates, that go from =TODAY() and then +7 until
October time. (So one entry a week based on todays date). I then have
created a combo box based on these dates and that works fine. I have
done a cell link to another cell, so I can use the date in some
conditional formatting, but the cell link just displays the position
in the combo box. Therefore my first date, is 01-01-1900 if I set
that field as date format or 1 if anything else. I have tried
changing the original input date to be Text. (i.e from original row of
date, =TXT(A1,"dd-mm-yyyy") and then referenced the text field as a
combo box, but still I just got the position in the combo box. Can
anyone help me get the correct date selected from the combo box into a
cell? Cheers, Rich

Combo box displays positions not date
 

Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.

Combo box properties

Input range Reference to the range containing the values to display in
the drop-down list.

Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.

For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:

=INDEX(D10:D15,C1)
or Choose(c1,d10,d11,d12,d13,d14,d15)

Drop-down lines Specifies the number of lines to display in the drop-down
list.


--
paul

remove nospam for email addy!



"Richhall" wrote:

Hi, I have a list of dates, that go from =TODAY() and then +7 until
October time. (So one entry a week based on todays date). I then have
created a combo box based on these dates and that works fine. I have
done a cell link to another cell, so I can use the date in some
conditional formatting, but the cell link just displays the position
in the combo box. Therefore my first date, is 01-01-1900 if I set
that field as date format or 1 if anything else. I have tried
changing the original input date to be Text. (i.e from original row of
date, =TXT(A1,"dd-mm-yyyy") and then referenced the text field as a
combo box, but still I just got the position in the combo box. Can
anyone help me get the correct date selected from the combo box into a
cell? Cheers, Rich

Combo box displays positions not date
 

Cheers, I ended just using LOOKUP based on the value returned from the
cell reference. Thanks for your help.

Cheers

Rich