Creating a ListBox from a Row of Cells

[Gareth050876]

Ive tried to add the contents of a Row of cells "B3:F3" from a sheet 'TOTALS' to a drop down box using the below code, the sheets cells contain dates formatted as Dates.

The output should look like this :

01-09-15
02-09-15
03-09-15
04-09-15
05-09-15

Please Login or Register  to view this content.

When i use the code the output is:

30-12-99
30-12-99
30-12-99
30-12-99
30-12-99

Ive also tried to use 'CDate' instead of 'Val' but i get a run time error. Any ideas on where i might be going wrong?

[Kamboj]

Sir You can use list row source property to show the value in list box
1. just name the range of your date
2. select list box and in property goto rowsource and than write name of the range items will display in list

[Kamboj]

sample file attached

[Gareth050876]

Thanks Kamboj

Unfortunately this only seems to work when the range is a Column, it doesnt work when the range is a Row. When the same principle is applied to a Row of Cells only the first Cell appears in the list, the following cells do not appear underneath as showen in the above output that i require.

[Kamboj]

FOR ROWS VALUES YOU CAN USE THIS CODE

Please Login or Register  to view this content.

[Kamboj]

if your data in range the use this

Please Login or Register  to view this content.