Horizontal Input for Combobox

[krais]

I have created the dropdown (combobox) from View --> Toolbars --> Forms
--> Combox

I have range of input ( Jan, Feb, ---- Dec) horizontally ( starting H28
to S28).
When I specify the range to combobox ( through right click Format
Control)
After finish I click on blank so dropdown remove its handle and click
dropdown button,
I am only getting "Jan" value It is not display all months.

I need help Is there any way to pass horizontal input to combobox(
dropdown) list.
I don't want to use combobox from Data --> Validation --> List due to
limitation of my work.

I appreciate if someone help me

Regards

 

[Guest]

why not to select in a vertical? create a vertical list in an auxiliar column
with formula looking for your horizontal data.

hth
regards from Brazil
Marcelo

"krais" escreveu:

 

[Dave Peterson]

How about creating a new sheet.

Then copy that range
off to the new sheet
edit|paste special|click Transpose.

Or use a formula on that new sheet:
Select A1:A12 and type this formula:
=transpose(sheet1!H28:s28)
but hit ctrl-shift-enter to fill all the cells.

Then name that range and use that name as the list in the Data|Validation cells.