| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding blank row and entering data in row from userform
I'm building a userform for test data entry that currently asks for 22 pieces
of information. I'm trying to take that information and enter it into the next blank row in the spreadsheet. This seems like a rather basic task, but I'm struggling. Please help! Thanks! Mark |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding blank row and entering data in row from userform
blankrow = cells(rows.count,"A").End(xlup).offset(1,0).row
uses column 1 to find the next blank cell. Adjust to suit. -- Regards, Tom Ogilvy "MAWII" wrote: I'm building a userform for test data entry that currently asks for 22 pieces of information. I'm trying to take that information and enter it into the next blank row in the spreadsheet. This seems like a rather basic task, but I'm struggling. Please help! Thanks! Mark |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding blank row and entering data in row from userform
Thanks, Tom. The problem I'm having is the next step. Having found the next
blank row, now how do I enter data into that row? "Tom Ogilvy" wrote: blankrow = cells(rows.count,"A").End(xlup).offset(1,0).row uses column 1 to find the next blank cell. Adjust to suit. -- Regards, Tom Ogilvy "MAWII" wrote: I'm building a userform for test data entry that currently asks for 22 pieces of information. I'm trying to take that information and enter it into the next blank row in the spreadsheet. This seems like a rather basic task, but I'm struggling. Please help! Thanks! Mark |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding blank row and entering data in row from userform
In a standard module include:
Sub Foo() Dim blankrow As Long blankrow = Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Row ' Toms line Range("A" & blankrow).Value = "something" 'Adjust to suit End Sub Jim "MAWII" wrote: Thanks, Tom. The problem I'm having is the next step. Having found the next blank row, now how do I enter data into that row? "Tom Ogilvy" wrote: blankrow = cells(rows.count,"A").End(xlup).offset(1,0).row uses column 1 to find the next blank cell. Adjust to suit. -- Regards, Tom Ogilvy "MAWII" wrote: I'm building a userform for test data entry that currently asks for 22 pieces of information. I'm trying to take that information and enter it into the next blank row in the spreadsheet. This seems like a rather basic task, but I'm struggling. Please help! Thanks! Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding data between blank rows | Excel Worksheet Functions | |||
| Userform Entering Data to a spreadsheet | Excel Programming | |||
| userform to search by entering data into a textbox | Excel Programming | |||
| Userform finding next row to place data | Excel Programming | |||
| Help finding data from userform | Excel Programming | |||
Hybrid Mode
