VBA - Textbox to new row line in sheet 1 within specific cell range

**hemal89** · 11-24-2014, 07:29 AM

Hi all,

Please can I request some assistance,

I am currently using the follwoing basic code :

Please Login or Register  to view this content.

However I need to be able to input the textbox inforamtion multiple times using the userform but each time the information needs to be placed in the next row down,
range is as follows:
A17 to V17 from row 5 down to row 60

All help will be much appreciated,

Many Thanks,

Hemal

**lokicl** · 11-24-2014, 07:40 AM

Hi Hemal,

You have find the last used row to fill your data.
The code below will update dynamically without any limits.
Hope this works out.

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.