Drop Down Box Selection

[zephyr]

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 can’t 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

 

[Gord Dibben]

What type of DropDown box?

If a Data Validation list just select the range across the row as the list
range.

i.e. J178:BA178


Gord Dibben MS Excel MVP

 

[Don]

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]

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