Send Userform data to selected row

[revenge4ash89]

Hi There,

Attached is a spreadsheet with a very basic userform. The userform is loaded when a cell in column A is selected. Currently, the data from the userform is sent to the first blank row; however I was wondering whether it was possible to send the data to the selected row. So for example if I selected "A9", the data from the userform would be sent to "B9, C9, D9" etc....

Here is the code I'm using:

Please Login or Register  to view this content.

Thanks for the help.

[tigeravatar]

Something like this?

Please Login or Register  to view this content.

[revenge4ash89]

Thank you so much Tigeravatar. I can't believe that's all it was. I spent hours trying to figure it out!