Userform query

[palaeontology]

I have a UserForm called ... TouchPadFor6

On the UserForm, I have ...

* a TextBox called .. TextBox1 .. which a user will type in a cell reference ... let's say E8

* a TextBox called .. TextBox3 .. which ...

if there are no timestamps in column N then it would display the same as TextBox1 (in this example .. E8)
if there is one timestamp in column N then it would display the cell location 1 cell lower than what is displayed in TextBox1 (in our example, it would be E9)
if there are two timestamps in column N then it would display the cell location 2 cells lower than what is displayed in TextBox1 (in our example, it would be E10)
etc etc etc

* a CommandButton called ... CommandButton97 ... which, when pressed, needs to do 3 things ...

1) send the 9 values in the range B2:B10 to 9 different cell locations ... given that our TextBox3 is saying E8, then ...

B2 would be sent to E8 .. same cell as indicated in TextBox3
B3 would be sent to F8 .. one cell to the right of what is indicated in TextBox3
B4 would be sent to G8 .. two cells to the right of what is indicated in TextBox3
B5 would be sent to I8 .. four cells to the right of what is indicated in TextBox3
B6 would be sent to J8 .. five cells to the right of what is indicated in TextBox3
B7 would be sent to K8 .. six cells to the right of what is indicated in TextBox3
B8 would be sent to M8 .. eight cells to the right of what is indicated in TextBox3
B9 would be sent to O8 .. ten cells to the right of what is indicated in TextBox3
B10 would be sent to Q8 .. twelve cells to the right of what is indicated in TextBox3

2) clear the contents of cells B2:B10 ready for the next entries

3) send a timestamp to the first available cell in Column N

So, finally to my query.... is someone able to help me with the code needed for both TextBox3, and Commandutton97 ?

Very, very kind regards,

Chris

 

[Fluff]

Glad to help & thanks for the feedback