Hi,
I am hoping to have a macro button initiate a pop up a
dialog box that contains a drop-down list box displaying a
certain range. When the user selects a name from the list
VBA will record the selection as a string.

I have been going through the help files and the only pop
up boxes I can find are the inputbox and msgbox. Is there
anyway to do this?

Thanks for all your help