Thank you very much! This is exactly what I wanted. I have a few questions though, as I have to use the list in multiple tabs and many times.
How can I create the list in another worksheet and call it from there, instead of creating the list on the same sheet where my validation list is?
I am going to use three workbooks with 40 tabs each, so how do I implement this code so that I don't have to paste this code for each of the 40 tabs in the three workbooks? Can I do something to have the code functionality available for the whole workbook, so that even if I create a new tab/worksheet and paste the content of one of the 40 tabs along with the dropdown lists, the code will function in the new worksheet without any additional programming?
I modified your code in the following way to make the code available for the whole workbook, but it is not working (I am not surprised as I don't have any VB coding knowledge):
I have the above code in Sheet1, and not in WorkBookObject as I don't know how to put the code in WorkBookObject to apply it to the whole workbook.
I have another code that will be running which enables multiple selection of items from the validation list. The following is the code:
Can I also do something that I don't have to copy the above code in each tab of the 40 tabs on the three workbooks?
Edit: I just found out that the above mentioned codes (your code and the one that use for multiple item selection) do not run on the same page in "View Code" of one sheet (code pasted as follows):
It gives me an error saying "Compile error: Ambiguous name detected: Worksheet_Change." Is it because both the codes have "Worksheet_Change" in them? I was just trying to see if these codes worked in harmony on one sheet. Of course, I am looking for an option that would enable me to run the codes on all worksheets by applying them to a workbook as opposed to just one worksheet.
I hope your eyes discover my post as I have to provide the codes tomorrow. Thank you very much for your help. I truly appreciate it.
Edit: I have made some changes in the workbook after some research and I am attaching my workbook with this post. The problem still remains. Now that I have merged both the codes, I am able to only make multiple selections, and not able to add items in the dropdown menu. My range is in sheet2, and the dropdown menu is in Sheet1 in cell A1. The code is in "Thisworkbook."