Forum Discussion
Solved
Need help setting up VBA Code for multiple list selections on 2 columns in Excel please
I have two separate columns that I need to set up for multiple selection. One is called 'Letters' and the other 'Notices' I have set up basic data validation but need to be able to select more that one from the drop down. I've watched many tutorials and tried codes but none seem to work, not sure where I am going wrong? Thank you to anyone taking the time to help today :) I've tried adding my sample excel data but it wont allow it.
See the attached workbook. You'll have to allow macros.
Right-click the sheet tab and select 'View Code' to inspect the VBA code.
4 Replies
=OFFSET(INDIRECT("A"&MATCH(I1,A:A,0)),,1,,4)
example file is inserted.
My answers are voluntary and without guarantee!
Hope this helps you.
Hi, thanks but this is not what I need. I need for example. For the Letters Column, to be able to select, one or all of the drop down list. So that in the 'Letters' Column for example. A1, I want to select multiple from the list. See example
See the attached workbook. You'll have to allow macros.
Right-click the sheet tab and select 'View Code' to inspect the VBA code.
