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

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


On Thu, 19 Jun 2008 13:24:03 -0700, 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 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

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

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