Hi there, Thanks for the tutorial it works for me. but I need more help my sheet is having so many columns and I want to do an exact dropdown thing for each coulmn.. can I do this for multiple columns if yes please let me know how.. thanks in advance.
To clarify what I mean is, each column in my worksheet is essentially a day, so I want to be able to use this function in column B (2), column C (3), column D (4) and so forth. Thanks!!!!
Do you have a video that teaches how to change values of multiple cells based on values form a drop down list. For example. I have a list of 5 products that come in 4 different colors. By selecting a color from the drop down list I like the 5 cells that show the cost of each window to change. Thank you.
Trying to use this for a 6 table sheet. How do I code for multiple tables? I'm making a quote sheet. In the "Quotes" worksheet you have a dropdown with Item names and after you select the Item it puts "ItemPrice" in the cell which is part of a larger formula to calculate total price.
Hello, This works in the beginning but for some reason it stops after awhile and only the value in the list comes up instead of the code from sheet "Codes". Is there any reason why that would happen? Thanks
I tried to use your solution but when i view the code nothing is their. please advice what to do to have this feature works in my spreadsheet. many thanks
Liana Melendez Does the sample file work correctly, and you're having problems adapting it to a different file? Or are you have this problem in the sample file? Make sure that your Trust settings allow macros to run, and enable macros when you open the file.
Is it possible to have this "Excel Drop Down List Automatically Changes Product Name to Code" combined with the "Autocomplete Entries With Excel Drop Down List"?
Hi, I love your tutorials and they have helped me a lot. I am relatively new to vba code and wondered how you could use this technique with combo boxes? I have seen your tutorials on combo boxes but would like to combine the the lessons here with returning a different column using offset but with combo boxes and not just the data validation list. Is it possible? Kind regards and thanks, Sean
I tried with above but it did not work. It seems that with mutiple lists and columns, the above is not working. Is it possible to get code only with multilple columns, sheets, lists?
I'm trying to do this in Excel2010. Cant' figure out how so see the code either. I know that some products seem to be headed away from VB. Is this one such instance?
At naming the range, the source contains "=Values!$C$2:$C$15". If I accept that, my dropdown just contains that range. If I overtype it with the correct information (in my case "=TABLE2(value_text)" it accepts it OK but, when I go to data Validation and select the named range, it tells me that the source evaluates to an error and nothing appears when I click on the drop-down. What am I doing wrong?
HI THERE. I WANT TO CREATE A DROP DOWN LIST WHERE IF YOU CHOOSE A PRODUCT CODE THE DESCRIPTION AUTOMATICALLY APPEARS IN THE NEXT CELL....HOW DO I LINK THE CODE SO THE DESCRIPTION, EVEN MAYBE THE PRICE WILL ALL APPEAR IN A SINGLE ROW??
This works only we have one list. If we have two lists the code is not working. Say I have Department 01 - SALES , 02 - MARKETING and designation 1 - manager, 2 - supervisor. How can create two lists to display the name and converts to code after selection. Ashok
Hello all, if you want the code you can download their example excel worksheet...it is stated in the information above. One question I have however, is when you look at the code it says "If Target.Column = 2 Then"....I got this code to work, but only for column 2...I want to have drop down boxes in various places through my worksheet, does anyone know how I can change the code so that this is possible. Ie. no restrictions on which column it has to be in.... it will be in many different columns.
Hello!. I'm using excel 2013. When I download your example files they won't work. Is it because of the version I'm using?. Can you help me figure out how to do this?
I have applied this and it works brilliantly. New to creating drop down lists and this tut is the best to teach that and more!
Thanks for sharing!
You're welcome, Zana, and thanks for your comment!
Finally one that works. All the other I found were reporting error or crashing excel in whole. THNX!!!
Great! Thanks for the walk-through and the sample code. Following this, I was able to accomplish my task. Much appreciated!
I cant see any code in my VBA sheet.
Hi there,
Thanks for the tutorial it works for me. but I need more help my sheet is having so many columns and I want to do an exact dropdown thing for each coulmn.. can I do this for multiple columns if yes please let me know how.. thanks in advance.
To clarify what I mean is, each column in my worksheet is essentially a day, so I want to be able to use this function in column B (2), column C (3), column D (4) and so forth. Thanks!!!!
what happens if nothing comes up in View Code? the values are not being brought over from the drop down options
THANK you very much.Solved a big problem
Do you have a video that teaches how to change values of multiple cells based on values form a drop down list. For example. I have a list of 5 products that come in 4 different colors. By selecting a color from the drop down list I like the 5 cells that show the cost of each window to change. Thank you.
Trying to use this for a 6 table sheet. How do I code for multiple tables?
I'm making a quote sheet. In the "Quotes" worksheet you have a dropdown with Item names and after you select the Item it puts "ItemPrice" in the cell which is part of a larger formula to calculate total price.
Sir can YOU give the the link to download this sheet please....
hello. can you show me, VBA code in this tutorial ? THANK YOU SO MUCH!
Hello, This works in the beginning but for some reason it stops after awhile and only the value in the list comes up instead of the code from sheet "Codes". Is there any reason why that would happen? Thanks
I tried to use your solution but when i view the code nothing is their. please advice what to do to have this feature works in my spreadsheet. many thanks
I followed this step-by-step and it's not working. When I select the dropdown item it doesn't put in just the code. I'm using Excel 2010.
Liana Melendez Does the sample file work correctly, and you're having problems adapting it to a different file? Or are you have this problem in the sample file?
Make sure that your Trust settings allow macros to run, and enable macros when you open the file.
Is it possible to have this "Excel Drop Down List Automatically Changes Product Name to Code" combined with the "Autocomplete Entries With Excel Drop Down List"?
Did you get the answer? Same predicament.
Hi,
I love your tutorials and they have helped me a lot. I am relatively new to vba code and wondered how you could use this technique with combo boxes? I have seen your tutorials on combo boxes but would like to combine the the lessons here with returning a different column using offset but with combo boxes and not just the data validation list. Is it possible?
Kind regards and thanks,
Sean
I tried with above but it did not work.
It seems that with mutiple lists and columns, the above is not working.
Is it possible to get code only with multilple columns, sheets, lists?
THANK YOU SO MUCH!
also, without the code drop down list doesn't change the product name to code. how can i have the code? thanks
I'm trying to do this in Excel2010. Cant' figure out how so see the code either. I know that some products seem to be headed away from VB. Is this one such instance?
At naming the range, the source contains "=Values!$C$2:$C$15". If I accept that, my dropdown just contains that range. If I overtype it with the correct information (in my case "=TABLE2(value_text)" it accepts it OK but, when I go to data Validation and select the named range, it tells me that the source evaluates to an error and nothing appears when I click on the drop-down. What am I doing wrong?
Got as far as the code, but I'm unable to view the code for some reason. Please advise. Thanks in advance.
If I want to repeat this for several columns how would I do that?
HI THERE. I WANT TO CREATE A DROP DOWN LIST WHERE IF YOU CHOOSE A PRODUCT CODE THE DESCRIPTION AUTOMATICALLY APPEARS IN THE NEXT CELL....HOW DO I LINK THE CODE SO THE DESCRIPTION, EVEN MAYBE THE PRICE WILL ALL APPEAR IN A SINGLE ROW??
+Tricia Marshall You could use a VLOOKUP formula in the next cell. There's an example in my video here: ruclips.net/video/FAzauT9DwkM/видео.html
This works only we have one list. If we have two lists the code is not working. Say I have Department 01 - SALES , 02 - MARKETING and designation 1 - manager, 2 - supervisor.
How can create two lists to display the name and converts to code after selection.
Ashok
Hello all, if you want the code you can download their example excel worksheet...it is stated in the information above. One question I have however, is when you look at the code it says "If Target.Column = 2 Then"....I got this code to work, but only for column 2...I want to have drop down boxes in various places through my worksheet, does anyone know how I can change the code so that this is possible. Ie. no restrictions on which column it has to be in.... it will be in many different columns.
Hello!. I'm using excel 2013. When I download your example files they won't work. Is it because of the version I'm using?. Can you help me figure out how to do this?
The files will work in Excel 2013, as long as you have macros enabled. There are instructions on my website:
www.contextures.com/xlvba01.html#security
how to get respective head name automatically .....if we are putting the name of team mates in excel sheet
Not Unresistant me, Change Model Excel Video sent it.