ExcelBanter - Macro for dropdown

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Macro for dropdown (https://www.excelbanter.com/excel-programming/285715-macro-dropdown.html)

Price

Macro for dropdown

I have a macro that copies a line from another sheet and pastes it to
the current cell.

On the line I have a dropdown box. It copies perfectly, but it
doesn't connect the dropdown box to the cell (linking it to D3).

How do I do this?

All times are GMT +1. The time now is 10:24 AM.