View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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