I'm trying to use the multiple selection dropdown list code and am having difficulty modifying. I'm working on creating a index for files and have a column to identify source, file contents and will be adding some keywords to identify what the information in the file is on, I want to be able to do multiple selection on each column as needed. I tried modifying the code but it isn't working.
File is attached.
Index : list of files columnds d,e,f are the selection lists (d may not actually need the multiple selection possibility, but e and f will)
Keywords: the lists for the selection lists being used on Index
Sheet 1:- separating the path from the file name
How do I get the multiple selection working on this. I tried searching the VBA forum but was getting too many unrelated articles to find anything that helped.
Thanks
Karen
Hi Karen,
Use :
If Not Intersect(Target, Me.Range("D:F")) Is Nothing Then
instead of:
If Not Intersect(Target, ThisWorkbook.Worksheets("Keywords").Range("Source,Type,Topics")) Is Nothing Then
Hi Catalin
Thank You. That worked and solved my problem
Karen
