How to use a Button to fill blank cells with a text value from another?

[curtistomas]

I am a beginner at VBA and I've spent a lot of time trying to search for help on solving this issue I am having...

I am trying to design a worksheet for users to complete.

I have 10 cells B3:B13 where the user can write free text. There are cells D3:D13 which either display "1" or "0" depending if they have completed a different part of the sheet. I also have cell B16 which is a free text cell for the user to complete.

I want to use an Active X Button, which when clicked, will populate any cell B3:B13 with the value of B16 if the value of D3:D13 is "0". If the value of D3:D13 is "1", I want the cell in B3:B13 to be left alone.

 

[curtistomas]

	Notes		Completed?
	Users Text...		1
	Users Text...		1
	Users Text...		1
			0
			0
			0
			0
			0
			0
			0
	Text:
	"This will appear in each blank cell."		[Button]

<tbody>
</tbody>