Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill a Combobox from a ROW?
Hello,
I might be to tired but I can't get it right. In a sheet I have a database with 8 columns. The first ROW holds the titles. I named the titlerange "Headings". (8 cells in 8 columns). I want a combobox to display all titles but as far as I can see a combobox only displays a column with data. How do I get my titles? Rob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill a Combobox from a ROW?
Are you using Data Validation to get your 'combo box'? Or are you actually
using a combo box control from the Forms or Controls Toolbox? If you're using Data Validation, it should be easy to do: Set the "Allow" entry in the validation setup dialog to "List" and then in the Source area type =Headings and the cell should show the entries in your row. "Rob" wrote: Hello, I might be to tired but I can't get it right. In a sheet I have a database with 8 columns. The first ROW holds the titles. I named the titlerange "Headings". (8 cells in 8 columns). I want a combobox to display all titles but as far as I can see a combobox only displays a column with data. How do I get my titles? Rob |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill a Combobox from a ROW?
Sorry for not telling that,
I'm just using a combobox control from the Forms toolbox on a other worksheet in the same workbook. I hope that provides you with the proper info. Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) schreef in bericht ... Are you using Data Validation to get your 'combo box'? Or are you actually using a combo box control from the Forms or Controls Toolbox? If you're using Data Validation, it should be easy to do: Set the "Allow" entry in the validation setup dialog to "List" and then in the Source area type =Headings and the cell should show the entries in your row. "Rob" wrote: Hello, I might be to tired but I can't get it right. In a sheet I have a database with 8 columns. The first ROW holds the titles. I named the titlerange "Headings". (8 cells in 8 columns). I want a combobox to display all titles but as far as I can see a combobox only displays a column with data. How do I get my titles? Rob |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill a Combobox from a ROW?
As you've found out, those guys don't like horizontal lists. What you might
consider doing if you really want that combo box is to make a vertical copy of your headers somewhere out of sight and use it as the source for the list. You can turn the headers vertical quickly with copy then Paste Special choosing the [Transpose] option. If you give that vertical copy of the list a name also, you can even put it on another sheet in the workbook (could be hidden) and use that name as the Input Range for it. Hope this helps some. "Rob" wrote: Sorry for not telling that, I'm just using a combobox control from the Forms toolbox on a other worksheet in the same workbook. I hope that provides you with the proper info. Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) schreef in bericht ... Are you using Data Validation to get your 'combo box'? Or are you actually using a combo box control from the Forms or Controls Toolbox? If you're using Data Validation, it should be easy to do: Set the "Allow" entry in the validation setup dialog to "List" and then in the Source area type =Headings and the cell should show the entries in your row. "Rob" wrote: Hello, I might be to tired but I can't get it right. In a sheet I have a database with 8 columns. The first ROW holds the titles. I named the titlerange "Headings". (8 cells in 8 columns). I want a combobox to display all titles but as far as I can see a combobox only displays a column with data. How do I get my titles? Rob |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill a Combobox from a ROW?
Hello,
it's a combobox from the controls toolbox on a sheet, I hope that helps you. Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) schreef in bericht ... Are you using Data Validation to get your 'combo box'? Or are you actually using a combo box control from the Forms or Controls Toolbox? If you're using Data Validation, it should be easy to do: Set the "Allow" entry in the validation setup dialog to "List" and then in the Source area type =Headings and the cell should show the entries in your row. "Rob" wrote: Hello, I might be to tired but I can't get it right. In a sheet I have a database with 8 columns. The first ROW holds the titles. I named the titlerange "Headings". (8 cells in 8 columns). I want a combobox to display all titles but as far as I can see a combobox only displays a column with data. How do I get my titles? Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Erase fill print then bring fill back | Excel Discussion (Misc queries) | |||
Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
The fill feature in Excel that gives option to fill or copy | New Users to Excel |