Can vba "find what" use a dropdown list box to be dynamic

[bowslam]

I'm using the find function in VBA. I want to use a dropdown list box with several names.
Can the dropdown list box location be used for the "what" in the Cells.Find(What:="dropdown list box" so the name picked
in the dropdown list box will be the name searched. See attached worksheet.

Thanks for your help.



Dropdown list box
JOHN



VBA CODE TO "FIND" . IN THE FIND(WHAT:="JOHN" IS THERE A WAY TO USE THE NAME IN THE DROP DOWN LIST BOX IN B2 TO MAKE IT DYNAMIC?
Cells.Find(WHAT:="JOHN", After:=ActiveCell, LookIn:= _
xlFormulas2, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate