I have a drop down menu in a Form,
I'd like to have it reference a specific name range in a sheet.
I have a formula that creates the dynamic range automatically.
let's say for example "dynRange" is the Name of it.

I'd like to have a user double click the cell the form opens.
And then they Can select two different drop downs and a certain value
appears from that.

Question: How do I reference a Named Range in a DropDown "Combo box" and
what's the code/event procedure for if a user double clicks a cell, then I
can do the open.form

Thank you in advance!