| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with combo box, please!!!!!!
Hi there,
I am creating a workbook and I can not find the way to make my combo box work how I want it to: I have a spreadsheet with names, colum a from 1 - 89. With this list I have created a combo box, on Colum B, from 1 - 89 rates ($). What I would like to do is every time I change the name in the combo box I want cell B to show me that persons rate. Is there anyone that can help!!!!! I've been working on this same problem for a week, I'm going crazy Please help!!! Thanks!!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with combo box, please!!!!!!
Hi Jessica if I understand what you have is
Col A Col B name1 $10.00 name2 $12.00 .... name88 $7.00 your combo box have a bond cell right? assuming it is on A100 this cell will change the value for each name select. insert a column before A, put an ID so COL A COL B COL C 1 name1 $10.00 use a =VLOOKUP($A$100,$A$1:$C$89,3,0) and excel will return the Col C value HTH Regards from Brazil Marcelo "Jessica C. Jara" escreveu: Hi there, I am creating a workbook and I can not find the way to make my combo box work how I want it to: I have a spreadsheet with names, colum a from 1 - 89. With this list I have created a combo box, on Colum B, from 1 - 89 rates ($). What I would like to do is every time I change the name in the combo box I want cell B to show me that persons rate. Is there anyone that can help!!!!! I've been working on this same problem for a week, I'm going crazy Please help!!! Thanks!!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with combo box, please!!!!!!
Marcelo!!! You did it, you're a genius. Thank you so much. I have been working with this all week!!!! Obrigado!!!! Moito (I think) Jessie "Marcelo" wrote: Hi Jessica if I understand what you have is Col A Col B name1 $10.00 name2 $12.00 ... name88 $7.00 your combo box have a bond cell right? assuming it is on A100 this cell will change the value for each name select. insert a column before A, put an ID so COL A COL B COL C 1 name1 $10.00 use a =VLOOKUP($A$100,$A$1:$C$89,3,0) and excel will return the Col C value HTH Regards from Brazil Marcelo "Jessica C. Jara" escreveu: Hi there, I am creating a workbook and I can not find the way to make my combo box work how I want it to: I have a spreadsheet with names, colum a from 1 - 89. With this list I have created a combo box, on Colum B, from 1 - 89 rates ($). What I would like to do is every time I change the name in the combo box I want cell B to show me that persons rate. Is there anyone that can help!!!!! I've been working on this same problem for a week, I'm going crazy Please help!!! Thanks!!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with combo box, please!!!!!!
thanks for the feedback and you are close is
Muito obrigado!!!! regards "Jessica C. Jara" escreveu: Marcelo!!! You did it, you're a genius. Thank you so much. I have been working with this all week!!!! Obrigado!!!! Moito (I think) Jessie "Marcelo" wrote: Hi Jessica if I understand what you have is Col A Col B name1 $10.00 name2 $12.00 ... name88 $7.00 your combo box have a bond cell right? assuming it is on A100 this cell will change the value for each name select. insert a column before A, put an ID so COL A COL B COL C 1 name1 $10.00 use a =VLOOKUP($A$100,$A$1:$C$89,3,0) and excel will return the Col C value HTH Regards from Brazil Marcelo "Jessica C. Jara" escreveu: Hi there, I am creating a workbook and I can not find the way to make my combo box work how I want it to: I have a spreadsheet with names, colum a from 1 - 89. With this list I have created a combo box, on Colum B, from 1 - 89 rates ($). What I would like to do is every time I change the name in the combo box I want cell B to show me that persons rate. Is there anyone that can help!!!!! I've been working on this same problem for a week, I'm going crazy Please help!!! Thanks!!!! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with combo box, please!!!!!!
Marcelo, I have another inconvenient: Though you did get that option awesome,
I need to do the same with another 5 options, is that possible to do? I'm trying it but it doesn't happen. ANy help appreciated. Thanks!!!! "Marcelo" wrote: thanks for the feedback and you are close is Muito obrigado!!!! regards "Jessica C. Jara" escreveu: Marcelo!!! You did it, you're a genius. Thank you so much. I have been working with this all week!!!! Obrigado!!!! Moito (I think) Jessie "Marcelo" wrote: Hi Jessica if I understand what you have is Col A Col B name1 $10.00 name2 $12.00 ... name88 $7.00 your combo box have a bond cell right? assuming it is on A100 this cell will change the value for each name select. insert a column before A, put an ID so COL A COL B COL C 1 name1 $10.00 use a =VLOOKUP($A$100,$A$1:$C$89,3,0) and excel will return the Col C value HTH Regards from Brazil Marcelo "Jessica C. Jara" escreveu: Hi there, I am creating a workbook and I can not find the way to make my combo box work how I want it to: I have a spreadsheet with names, colum a from 1 - 89. With this list I have created a combo box, on Colum B, from 1 - 89 rates ($). What I would like to do is every time I change the name in the combo box I want cell B to show me that persons rate. Is there anyone that can help!!!!! I've been working on this same problem for a week, I'm going crazy Please help!!! Thanks!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro that can run combo boxes | Excel Discussion (Misc queries) | |||
| Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
| Dynamic Combo Box | Excel Worksheet Functions | |||
| connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
| dynamic combo boxes | Excel Worksheet Functions | |||
Hybrid Mode
