Horizontal Input for Combobox
 

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

Horizontal Input for Combobox
 

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:

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

Horizontal Input for Combobox
 

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.

krais wrote:

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

--

Dave Peterson