Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox
I would like to use a ComboBox with a row of data as "Input Range".
Apparently it "accept" only data in column. Why? can I do something to use data in rows? Is there a way to chnge the font size in the ComboBox? Sincerely yours Avner Mediouni R&D Physicist |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox
You used the term "input range". That sounds like you used a dropdown from the
Forms toolbar. You can't change the font on that one. But if you chose the combobox from the controltoolbox toolbar, you could: Show that control toolbox toolbar and click on the "design mode" icon. Then right click on the combobox and choose properties. There's a Font property that you can change. You could use code to use data in a row instead of a column. Maybe in your auto_open/workbook_open code???? With Worksheets("sheet1") .DropDowns("drop down 1").List _ = Application.Transpose(.Range("A6", .Range("IV6").End(xlToLeft))) End With Another option is to use a different range (on a hidden worksheet) and transpose the "real" range there. You could copy|Paste special|Transpose or even just: select the same number of cells (26 in my example below) type your formula: =transpose(sheet1!a6:Z6) hit ctrl-shift-enter and use that as your input range. Avner Mediouni wrote: I would like to use a ComboBox with a row of data as "Input Range". Apparently it "accept" only data in column. Why? can I do something to use data in rows? Is there a way to chnge the font size in the ComboBox? Sincerely yours Avner Mediouni R&D Physicist -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
combobox changes value | Excel Discussion (Misc queries) | |||
combobox value | Excel Discussion (Misc queries) | |||
combobox | Excel Discussion (Misc queries) | |||
Combobox | Excel Programming |