Dynamic Dropdown Showing Results From More Than One Column

[BDBJ1]

Below is working code for a dynamic dropdown list with content taken from column A for ContentforDropdownBox.xlsm:

Please Login or Register  to view this content.

Column A contains project numbers while column R contains project names.

I would like the result of the dropdown to show both column A and column R as follows: ProjectNumber-ProjectName

Is this possible?

[Tinbendr]

What about?

Please Login or Register  to view this content.

[BDBJ1]

Using that I'm now getting 'Type mismatch (Error 13)'

[Tinbendr]

Hmm.... try removing the .Value from each one. Or change to .Text.

Or

Please Login or Register  to view this content.

[BDBJ1]

Brilliant. That worked. Thanks for your help.