Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I create Combo list with no VBA
I would like to create drop down list the old fashioned way. I know nothing
about VBA or ActiveX. Previous version of excel allowed you to create a control with a drop down list which after selection will put the output in a specific field on which calculation could start. Is there a way to get Excel to work the old way |
#2
|
|||
|
|||
How can I create Combo list with no VBA
Open up the control tool box.
Select the combo box and place it on your worksheet. Put the list of values that you want in a column range somewhere. Open the properties for the combo box. Enter the range with your values in the ListFillRange property, like A2:A10 Enter the cell where you want your selection to appear in the LinkedCell property, like F1. This should do it. If you don't need a linked cell, you could use data validation instead of a combo box. Art "Etiene" wrote: I would like to create drop down list the old fashioned way. I know nothing about VBA or ActiveX. Previous version of excel allowed you to create a control with a drop down list which after selection will put the output in a specific field on which calculation could start. Is there a way to get Excel to work the old way |
#3
|
|||
|
|||
How can I create Combo list with no VBA
Thanks a lot, it does work.
"Art" wrote: Open up the control tool box. Select the combo box and place it on your worksheet. Put the list of values that you want in a column range somewhere. Open the properties for the combo box. Enter the range with your values in the ListFillRange property, like A2:A10 Enter the cell where you want your selection to appear in the LinkedCell property, like F1. This should do it. If you don't need a linked cell, you could use data validation instead of a combo box. Art "Etiene" wrote: I would like to create drop down list the old fashioned way. I know nothing about VBA or ActiveX. Previous version of excel allowed you to create a control with a drop down list which after selection will put the output in a specific field on which calculation could start. Is there a way to get Excel to work the old way |
#4
|
|||
|
|||
How can I create Combo list with no VBA
OK, and what if I want to show two colums (the first one being the
description and the second being the data) and then excel only copy the second column value to another field). Sounds like a lookup system in Acess. Thanks for the help. Regards, Etienne "Art" wrote: Open up the control tool box. Select the combo box and place it on your worksheet. Put the list of values that you want in a column range somewhere. Open the properties for the combo box. Enter the range with your values in the ListFillRange property, like A2:A10 Enter the cell where you want your selection to appear in the LinkedCell property, like F1. This should do it. If you don't need a linked cell, you could use data validation instead of a combo box. Art "Etiene" wrote: I would like to create drop down list the old fashioned way. I know nothing about VBA or ActiveX. Previous version of excel allowed you to create a control with a drop down list which after selection will put the output in a specific field on which calculation could start. Is there a way to get Excel to work the old way |
#5
|
|||
|
|||
How can I create Combo list with no VBA
Not a problem -- you don't need Access.
Setup your lookups like this: A B 1 Val 1 123 2 Val 2 155 3 Val 3 123 4 Val 4 164 ListFillRange: A1:B4 LinkedCell: F1 ColumnCount: 2 BoundColumn: 2 You can change the column widths like: ColumnWidths: 20pt ; 20pt (for example) This should do it. Art "Etiene" wrote: OK, and what if I want to show two colums (the first one being the description and the second being the data) and then excel only copy the second column value to another field). Sounds like a lookup system in Acess. Thanks for the help. Regards, Etienne "Art" wrote: Open up the control tool box. Select the combo box and place it on your worksheet. Put the list of values that you want in a column range somewhere. Open the properties for the combo box. Enter the range with your values in the ListFillRange property, like A2:A10 Enter the cell where you want your selection to appear in the LinkedCell property, like F1. This should do it. If you don't need a linked cell, you could use data validation instead of a combo box. Art "Etiene" wrote: I would like to create drop down list the old fashioned way. I know nothing about VBA or ActiveX. Previous version of excel allowed you to create a control with a drop down list which after selection will put the output in a specific field on which calculation could start. Is there a way to get Excel to work the old way |
#6
|
|||
|
|||
How can I create Combo list with no VBA
thanks a lot
"Art" wrote: Not a problem -- you don't need Access. Setup your lookups like this: A B 1 Val 1 123 2 Val 2 155 3 Val 3 123 4 Val 4 164 ListFillRange: A1:B4 LinkedCell: F1 ColumnCount: 2 BoundColumn: 2 You can change the column widths like: ColumnWidths: 20pt ; 20pt (for example) This should do it. Art "Etiene" wrote: OK, and what if I want to show two colums (the first one being the description and the second being the data) and then excel only copy the second column value to another field). Sounds like a lookup system in Acess. Thanks for the help. Regards, Etienne "Art" wrote: Open up the control tool box. Select the combo box and place it on your worksheet. Put the list of values that you want in a column range somewhere. Open the properties for the combo box. Enter the range with your values in the ListFillRange property, like A2:A10 Enter the cell where you want your selection to appear in the LinkedCell property, like F1. This should do it. If you don't need a linked cell, you could use data validation instead of a combo box. Art "Etiene" wrote: I would like to create drop down list the old fashioned way. I know nothing about VBA or ActiveX. Previous version of excel allowed you to create a control with a drop down list which after selection will put the output in a specific field on which calculation could start. Is there a way to get Excel to work the old way |
#7
|
|||
|
|||
How can I create Combo list with no VBA
How about if the data are in another tab.
How do you rename ListFillRange My tab is called Data "Art" wrote: Not a problem -- you don't need Access. Setup your lookups like this: A B 1 Val 1 123 2 Val 2 155 3 Val 3 123 4 Val 4 164 ListFillRange: A1:B4 LinkedCell: F1 ColumnCount: 2 BoundColumn: 2 You can change the column widths like: ColumnWidths: 20pt ; 20pt (for example) This should do it. Art "Etiene" wrote: OK, and what if I want to show two colums (the first one being the description and the second being the data) and then excel only copy the second column value to another field). Sounds like a lookup system in Acess. Thanks for the help. Regards, Etienne "Art" wrote: Open up the control tool box. Select the combo box and place it on your worksheet. Put the list of values that you want in a column range somewhere. Open the properties for the combo box. Enter the range with your values in the ListFillRange property, like A2:A10 Enter the cell where you want your selection to appear in the LinkedCell property, like F1. This should do it. If you don't need a linked cell, you could use data validation instead of a combo box. Art "Etiene" wrote: I would like to create drop down list the old fashioned way. I know nothing about VBA or ActiveX. Previous version of excel allowed you to create a control with a drop down list which after selection will put the output in a specific field on which calculation could start. Is there a way to get Excel to work the old way |
#8
|
|||
|
|||
How can I create Combo list with no VBA
If your data is on sheet1 and your combo box is on sheet2, the fill range
should look like: sheet1!a2:b5 for example. "Etiene" wrote: How about if the data are in another tab. How do you rename ListFillRange My tab is called Data "Art" wrote: Not a problem -- you don't need Access. Setup your lookups like this: A B 1 Val 1 123 2 Val 2 155 3 Val 3 123 4 Val 4 164 ListFillRange: A1:B4 LinkedCell: F1 ColumnCount: 2 BoundColumn: 2 You can change the column widths like: ColumnWidths: 20pt ; 20pt (for example) This should do it. Art "Etiene" wrote: OK, and what if I want to show two colums (the first one being the description and the second being the data) and then excel only copy the second column value to another field). Sounds like a lookup system in Acess. Thanks for the help. Regards, Etienne "Art" wrote: Open up the control tool box. Select the combo box and place it on your worksheet. Put the list of values that you want in a column range somewhere. Open the properties for the combo box. Enter the range with your values in the ListFillRange property, like A2:A10 Enter the cell where you want your selection to appear in the LinkedCell property, like F1. This should do it. If you don't need a linked cell, you could use data validation instead of a combo box. Art "Etiene" wrote: I would like to create drop down list the old fashioned way. I know nothing about VBA or ActiveX. Previous version of excel allowed you to create a control with a drop down list which after selection will put the output in a specific field on which calculation could start. Is there a way to get Excel to work the old way |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a list when it is not in the Data tool bar? | Excel Discussion (Misc queries) | |||
Create a list range | Excel Worksheet Functions | |||
How do I create multiple columns from a one-column list in Excel? | Excel Worksheet Functions | |||
Create a pick list to use to go to a text cell in Excel | Excel Worksheet Functions | |||
how do i create a list from a cell? | New Users to Excel |