Enter Userform Data into a range of Cells for Excel 2007

Hi,
I am trying to enter the Data from my userform in Excel 2007 to a range of cells. The Range is from A8:M51. I can use this formula below to add the Data but it puts it into Row 60??? This Range is enclosed around other cells with data, so I am not sure if that is why it starts at Row 60? I also need this to clear and have the next data entered into the row below. So Row "A8" should be the first row of Data and when I click on the button to add Data, the userform will clear and I can enter new Data and it would be inserted on Row "A9" when the Add Data button is clicked again.

Please Login or Register  to view this content.

Thanks in Advance

I attached the Sheet that I am trying to input the Data. I tried the code Given but it gives me a Run-time error '1004': Method 'Range' of object'_Worksheet' failed.

Sorry, Try this one.

It looked like it was working; however, when I deleted the data to start from Row 8 (A cleared Worksheet), it entered the data in row 8 but when I tried to add the next row of data it is no where to be found. I still get the "Data Added" msg box saying that it added. I reopened yours and cleared the data and started fresh and it did the same thing. It is not putting any more data in the cells once the first row of data is added. Yours did work when I first opened it and the first couple of rows where you had tested was there. I ran the userform and it followed right in line, but it seems once it is cleared it doesn't work anymore?? Suggestions?

It looks good so far. Thank you very much.

Is there any way to only allow the userform to appear if say I only have "x" amount of data to put in? The Data on the sheet that I entered varies from task to task so I may only input 2 rows of data or it could be the whole page. The numbers auto populate from another sheet into the "Isolation Point No." Column, which is the second column. I would like my userform to reference this column and have the userform close once the desired amount is reached? Thanks

Your post helped me out Naveed. I was just trying to expand my userform effeciency a bit. Ex. if "Isolation Point No" column has only 5 points (1,2,3,4,5) listed, then I only wanted the userform to enter data into rows 8,9,10,11,12.

Close.....B8:B51 will auto populate from another sheet and will be labeled 1-44 in numerical order. They will only have a value if that amount is required. If I only have 6 points, then cell B8 will be a value of 1, B9 will be a value of 2, B10=3, B11=4 and so on.....Sooo if I have say 15 points, then B8:B22 will have a numeric value of 1-15 in numerical order; therefore I would want my userform to auto close once the 15th and final row of data is input onto the data sheet from my user form... I'm not sure if this can even be done? It would just be a nice feature to add. Thanks

Close....B8:B51 will be numbered 1-44. The amount of numbered points will vary each time and will be automatically updated from another worksheet in the workbook. So B8=1, B9=2, B10=3, and so on. Example: If I have 6 points the B8:B13 will be numbered in numerical order from 1-6 (B8=1, B9=2.....B12=5, B13=6). I want my userform to stop entering data and close once the last row of data needed is added. So for this case I would need my userform to close once row 13's data has been added. Thanks. I don't even know if this is possible, but it would make my userform just a little more efficient.