Dropdown box populating another cell with 0

[AMorgan]

I have a dropdown list in a cell that populates a cell in another spreadsheet. The formula is =worksheet!A20
however, if nothing is selected in the dropdown list, the cell in the other spreadsheet shows 0.
How do I stop the cell from populating with 0? I want the cell left blank if nothing is selected from the dropdown box.

 

[syntaxed]

Glad it worked for the first letter.
In the second letter, did you change the Set myRange statement to:

Set myRange = Range("a21:b32")

 

[AMorgan]

All's good now! Thanks once again! It's a pleasure to watch the code work!!!

 

[AMorgan]

My spreadsheet now works perfectly, however, because of all the coding, is very slow when making changes. Is there any way of making it work faster?