storing input from input box

[calmena]

Hi,

I have a selectable range from B17:B43. The user will select cell B17, and an input box will appear, and I want to store that input into cell C17. Then when the user selects B18, I want to store that input in cell C18, and so on, thus building a database range from C17:C43, but I don't know how to do this.

Any help is appreciated. Thanks a bunch!

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here