| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Combo box - need idiots guide!
I want to use a combo box as a drop down list. I know where to find the combo
box (in the control toolbox), but I have no idea how to populate it or activate it... Any help will be appriciated for this real novice Rob. |
|
#2
|
|||
|
|||
|
Assuming you want a combo box in sheet 1:
Make a list in sheet, lets say A1:A5. Name this list "mylist' Draw your combo box in sheet one. Right click on it and choose format control. the input range would be =mylist the cell link will be anywhere you want (such as C10) Depending on what you choose from the drop down, C10 will change accordingly. HTH For more help, check out contextures.com "abfabrob" wrote: I want to use a combo box as a drop down list. I know where to find the combo box (in the control toolbox), but I have no idea how to populate it or activate it... Any help will be appriciated for this real novice Rob. |
|
#3
|
|||
|
|||
|
I'm sorry, I really don't understand. Can you explain in more detail? I'm
really new to this. I don't know what you mean by naming the list (where/how do I name it?). When I right click on the Combo box and go to format control, I don't know where to input anything. And do I OLNY input "=mylist"? And where do I input the fact that I want it to be in cell C10? (or whichever I decide to use). Hope you can help! "Anthony Slater" wrote: Assuming you want a combo box in sheet 1: Make a list in sheet, lets say A1:A5. Name this list "mylist' Draw your combo box in sheet one. Right click on it and choose format control. the input range would be =mylist the cell link will be anywhere you want (such as C10) Depending on what you choose from the drop down, C10 will change accordingly. HTH For more help, check out contextures.com "abfabrob" wrote: I want to use a combo box as a drop down list. I know where to find the combo box (in the control toolbox), but I have no idea how to populate it or activate it... Any help will be appriciated for this real novice Rob. |
|
#4
|
|||
|
|||
|
Ok, lets make it simpler
1. Fill sheet 1 A1:A5 with some data such as Apple, banana, pear, orange, lemon 2. Draw combo box somewhere on sheet 1 3. right click on combox 4. format control 5. Input range will be A1:A5 6. Cell link will A10 Thats it. When you click on the drop down, the list will show. Click on an item in the list will change the value accordingly in cel A10 You can then use the value in cell A10 in another formula depending on what you really need from the out come. Such as IF(a10=1,"APPLE","ANOTHER KIND OF FRUIT") Don't forget to check contextures.com for more help "abfabrob" wrote: I'm sorry, I really don't understand. Can you explain in more detail? I'm really new to this. I don't know what you mean by naming the list (where/how do I name it?). When I right click on the Combo box and go to format control, I don't know where to input anything. And do I OLNY input "=mylist"? And where do I input the fact that I want it to be in cell C10? (or whichever I decide to use). Hope you can help! "Anthony Slater" wrote: Assuming you want a combo box in sheet 1: Make a list in sheet, lets say A1:A5. Name this list "mylist' Draw your combo box in sheet one. Right click on it and choose format control. the input range would be =mylist the cell link will be anywhere you want (such as C10) Depending on what you choose from the drop down, C10 will change accordingly. HTH For more help, check out contextures.com "abfabrob" wrote: I want to use a combo box as a drop down list. I know where to find the combo box (in the control toolbox), but I have no idea how to populate it or activate it... Any help will be appriciated for this real novice Rob. |
|
#5
|
|||
|
|||
|
Thank you for this.
However... when I click on format control, there is no where to input the cell range. My options a "size", "protection", "properties" and "web". Rob "Anthony Slater" wrote: Ok, lets make it simpler 1. Fill sheet 1 A1:A5 with some data such as Apple, banana, pear, orange, lemon 2. Draw combo box somewhere on sheet 1 3. right click on combox 4. format control 5. Input range will be A1:A5 6. Cell link will A10 Thats it. When you click on the drop down, the list will show. Click on an item in the list will change the value accordingly in cel A10 You can then use the value in cell A10 in another formula depending on what you really need from the out come. Such as IF(a10=1,"APPLE","ANOTHER KIND OF FRUIT") Don't forget to check contextures.com for more help "abfabrob" wrote: I'm sorry, I really don't understand. Can you explain in more detail? I'm really new to this. I don't know what you mean by naming the list (where/how do I name it?). When I right click on the Combo box and go to format control, I don't know where to input anything. And do I OLNY input "=mylist"? And where do I input the fact that I want it to be in cell C10? (or whichever I decide to use). Hope you can help! "Anthony Slater" wrote: Assuming you want a combo box in sheet 1: Make a list in sheet, lets say A1:A5. Name this list "mylist' Draw your combo box in sheet one. Right click on it and choose format control. the input range would be =mylist the cell link will be anywhere you want (such as C10) Depending on what you choose from the drop down, C10 will change accordingly. HTH For more help, check out contextures.com "abfabrob" wrote: I want to use a combo box as a drop down list. I know where to find the combo box (in the control toolbox), but I have no idea how to populate it or activate it... Any help will be appriciated for this real novice Rob. |
|
#6
|
|||
|
|||
|
On the Control toolbox, click the Design mode button
Select the combo box On the Control toolbox, click the Properties button In the Properties window, for ListFillRange, type the name, or cell references, of your input range. Click the Exit Design Mode button. abfabrob wrote: Thank you for this. However... when I click on format control, there is no where to input the cell range. My options a "size", "protection", "properties" and "web". Rob "Anthony Slater" wrote: Ok, lets make it simpler 1. Fill sheet 1 A1:A5 with some data such as Apple, banana, pear, orange, lemon 2. Draw combo box somewhere on sheet 1 3. right click on combox 4. format control 5. Input range will be A1:A5 6. Cell link will A10 Thats it. When you click on the drop down, the list will show. Click on an item in the list will change the value accordingly in cel A10 You can then use the value in cell A10 in another formula depending on what you really need from the out come. Such as IF(a10=1,"APPLE","ANOTHER KIND OF FRUIT") Don't forget to check contextures.com for more help "abfabrob" wrote: I'm sorry, I really don't understand. Can you explain in more detail? I'm really new to this. I don't know what you mean by naming the list (where/how do I name it?). When I right click on the Combo box and go to format control, I don't know where to input anything. And do I OLNY input "=mylist"? And where do I input the fact that I want it to be in cell C10? (or whichever I decide to use). Hope you can help! "Anthony Slater" wrote: Assuming you want a combo box in sheet 1: Make a list in sheet, lets say A1:A5. Name this list "mylist' Draw your combo box in sheet one. Right click on it and choose format control. the input range would be =mylist the cell link will be anywhere you want (such as C10) Depending on what you choose from the drop down, C10 will change accordingly. HTH For more help, check out contextures.com "abfabrob" wrote: I want to use a combo box as a drop down list. I know where to find the combo box (in the control toolbox), but I have no idea how to populate it or activate it... Any help will be appriciated for this real novice Rob. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#7
|
|||
|
|||
|
that's really useful thing to use the combo box, but here I have the question
regarding it: I am using Combo-Box and when I click on the button to choose the data it appears to the linked cell as it should be everything works fine, but I need to see the data in the linked cell but not hte count number. For example, I have 10 different numbers in A1:a10 range and my linked cell is C10, i want that when I click on the second one there must be a second number in the linked cell and not the 2, Is it possible? Hope you understand the task. I would be really appreciate for your help. Thank you in advance Regards Alex "Debra Dalgleish" wrote: On the Control toolbox, click the Design mode button Select the combo box On the Control toolbox, click the Properties button In the Properties window, for ListFillRange, type the name, or cell references, of your input range. Click the Exit Design Mode button. abfabrob wrote: Thank you for this. However... when I click on format control, there is no where to input the cell range. My options a "size", "protection", "properties" and "web". Rob "Anthony Slater" wrote: Ok, lets make it simpler 1. Fill sheet 1 A1:A5 with some data such as Apple, banana, pear, orange, lemon 2. Draw combo box somewhere on sheet 1 3. right click on combox 4. format control 5. Input range will be A1:A5 6. Cell link will A10 Thats it. When you click on the drop down, the list will show. Click on an item in the list will change the value accordingly in cel A10 You can then use the value in cell A10 in another formula depending on what you really need from the out come. Such as IF(a10=1,"APPLE","ANOTHER KIND OF FRUIT") Don't forget to check contextures.com for more help "abfabrob" wrote: I'm sorry, I really don't understand. Can you explain in more detail? I'm really new to this. I don't know what you mean by naming the list (where/how do I name it?). When I right click on the Combo box and go to format control, I don't know where to input anything. And do I OLNY input "=mylist"? And where do I input the fact that I want it to be in cell C10? (or whichever I decide to use). Hope you can help! "Anthony Slater" wrote: Assuming you want a combo box in sheet 1: Make a list in sheet, lets say A1:A5. Name this list "mylist' Draw your combo box in sheet one. Right click on it and choose format control. the input range would be =mylist the cell link will be anywhere you want (such as C10) Depending on what you choose from the drop down, C10 will change accordingly. HTH For more help, check out contextures.com "abfabrob" wrote: I want to use a combo box as a drop down list. I know where to find the combo box (in the control toolbox), but I have no idea how to populate it or activate it... Any help will be appriciated for this real novice Rob. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#8
|
|||
|
|||
|
If you use the combo box from the Control tool box, it will display the
selected value in the linked cell. If you use the combo box from the Forms toolbar, it will display the item number in the linked cell. Alex wrote: that's really useful thing to use the combo box, but here I have the question regarding it: I am using Combo-Box and when I click on the button to choose the data it appears to the linked cell as it should be everything works fine, but I need to see the data in the linked cell but not hte count number. For example, I have 10 different numbers in A1:a10 range and my linked cell is C10, i want that when I click on the second one there must be a second number in the linked cell and not the 2, Is it possible? Hope you understand the task. I would be really appreciate for your help. Thank you in advance Regards Alex "Debra Dalgleish" wrote: On the Control toolbox, click the Design mode button Select the combo box On the Control toolbox, click the Properties button In the Properties window, for ListFillRange, type the name, or cell references, of your input range. Click the Exit Design Mode button. abfabrob wrote: Thank you for this. However... when I click on format control, there is no where to input the cell range. My options a "size", "protection", "properties" and "web". Rob "Anthony Slater" wrote: Ok, lets make it simpler 1. Fill sheet 1 A1:A5 with some data such as Apple, banana, pear, orange, lemon 2. Draw combo box somewhere on sheet 1 3. right click on combox 4. format control 5. Input range will be A1:A5 6. Cell link will A10 Thats it. When you click on the drop down, the list will show. Click on an item in the list will change the value accordingly in cel A10 You can then use the value in cell A10 in another formula depending on what you really need from the out come. Such as IF(a10=1,"APPLE","ANOTHER KIND OF FRUIT") Don't forget to check contextures.com for more help "abfabrob" wrote: I'm sorry, I really don't understand. Can you explain in more detail? I'm really new to this. I don't know what you mean by naming the list (where/how do I name it?). When I right click on the Combo box and go to format control, I don't know where to input anything. And do I OLNY input "=mylist"? And where do I input the fact that I want it to be in cell C10? (or whichever I decide to use). Hope you can help! "Anthony Slater" wrote: Assuming you want a combo box in sheet 1: Make a list in sheet, lets say A1:A5. Name this list "mylist' Draw your combo box in sheet one. Right click on it and choose format control. the input range would be =mylist the cell link will be anywhere you want (such as C10) Depending on what you choose from the drop down, C10 will change accordingly. HTH For more help, check out contextures.com "abfabrob" wrote: I want to use a combo box as a drop down list. I know where to find the combo box (in the control toolbox), but I have no idea how to populate it or activate it... Any help will be appriciated for this real novice Rob. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#9
|
|||
|
|||
|
Dear Debra,
Thank you for you kind and timely support I really appreciate for your help. All i have to do now is to define the list range and link cell in the properties of the Combo Box. Once Again Thank You "Debra Dalgleish" wrote: If you use the combo box from the Control tool box, it will display the selected value in the linked cell. If you use the combo box from the Forms toolbar, it will display the item number in the linked cell. Alex wrote: that's really useful thing to use the combo box, but here I have the question regarding it: I am using Combo-Box and when I click on the button to choose the data it appears to the linked cell as it should be everything works fine, but I need to see the data in the linked cell but not hte count number. For example, I have 10 different numbers in A1:a10 range and my linked cell is C10, i want that when I click on the second one there must be a second number in the linked cell and not the 2, Is it possible? Hope you understand the task. I would be really appreciate for your help. Thank you in advance Regards Alex |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Combo Box | Excel Worksheet Functions | |||
| connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
| "Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
| dynamic combo boxes | Excel Worksheet Functions | |||
| How do I autofill combo boxes with their destination cell? | Excel Worksheet Functions | |||
Linear Mode
