List Box into a cell

[Guest]

Newbie list box question.

I would like to create a list box with entries from a named range "FRA"

When I select a entry from the list box I would like to call a macro.

Can someone help me with the code to create a listbox in whatever the
activecell is?

Thanks for the help

 

[Guest]

Try: in cell C2
Data Validation List
( in sourse box write =FRA )

put this in Sheets-kode-window:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("C2")) Is Nothing Then Exit Sub
MsgBox ("Selected list-value : ") & Target
End Sub