Create a drop down list based on the value in a cell

This works absolutely beautifully. I think I may be a little dense. How do I duplicate it, I could only find this VBA code in the workbook:

Sub VBAReferences()

  Dim Ref As Object
  Dim Refs As Object
  Dim VBproj As Object
  
    Set VBproj = ThisWorkbook.VBProject
    Set Refs = VBproj.References
    
      For Each Ref In Refs
        N = Ref.Name
        D = Ref.Description
        P = Ref.FullPath
        T = Ref.Type
      Next Ref
        
End Sub

How do I duplicate your drop downs? I can't see how to set them the way you have. Sorry to not get it...

Thanks.

Veronica

Hello vjboaz,

Sorry about the VBA code. That was a answer to another post. Forgot to remove it. The worksheet uses only validation drop downs and named ranges. Click on the drop down > Data > Validation... to see the references to the named ranges.

Sincerely,
Leith Ross

Thanks so much... it was the reference code that kind of confused me.

It works perfectly.

Veronica

6 years ago! I hope you're still reading these! I'm so close to getting this right on my own spreadsheet, but when I create the list and input the source =INDIRECT(ListName), I get an error: "The Source currently evaluates to an error. Do you want to continue?" Can you help me fix this?

ameyzing1