Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input Cell | Excel Worksheet Functions | |||
how to extract input data? | Excel Worksheet Functions | |||
input box | Excel Discussion (Misc queries) | |||
Input Form vba help | Excel Discussion (Misc queries) | |||
can you input time (hh:mm:ss) without having to input the colon i. | Excel Discussion (Misc queries) |