The drop down box is a combo box. The control is formatted as follows:

Input Range: $J$178: $P$178
Cell Link: $A$178

Only the contents of cell $J178 is shown in the drop down box.

Regards

Zephyr


"Don" wrote:

I am not sure I understand the question. If you have data from A1 - G1 and
you select that range then in the box above the A where it should say A1,
type in LISTTEST. Then select the range you want to have a drop down box and
do list and =LISTTEST in the Source, then you should get a list from A1 - G1?
Are you trying to do something else and I missed something? You would
usualy have the list going down , but going across is ok too.

"zephyr" wrote:

I have a drop down box; the input range is from a row not a column. The
selection in the drop down box appears when the input range is from a column.
I cant get it to work when a row is selected. I would like to have the
selection from a row.

The row starts from cell J178 onwards. Is there a way to get the row to
appear in the drop down box?

Many thanks