![]() ![]() If Target.Column = 3 or Target.Column = 4 Then Q: I need to create multiple drop-downs in a row. On similar lines, if you want this functionality in column C and D, use the below line: How do I get this for all the cells in the columns with multi-select functionality?Īns: To enable multiple selections in drop-downs in an entire column, replace the following line in the code: If Target.Address = "$C$2" Or Target.Address = "$C$3" Or Target.Address = "$C$4" Then Q: I need to create multiple drop-downs in entire column 'C'. Suppose you want to get this for C2, C3, and C4, you need to replace the following line in the code: How do I get it for other cells?Īns: To get this multiple selection drop-down in other cells, you need to modify the VBA code in the backend. Q: In the VBA code, the functionality is for cell C2 only. If you have any questions, I request you to go through this list of queries first. I have created this section to answer some of the most asked questions about this tutorial and the VBA code. Note: Since we are using a VBA code to get this done, you need to save the workbook with a. Now when you go back to the drop-down and make selections, it will allow you to make multiple selections (as shown below):
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |