PDA

View Full Version : Row entry without keeping any row blank



sujittalukde
07-20-2007, 01:12 AM
I need a solution to a problem whereby a user shall be forced to make data entry in continuous rows. ie if a user make entries at row 2, row 3 he would not be able to make entry at row 4 .

In other words, suppose a user has to make three entries . He has to use use the first three rows starting from row2 as row1 will contain header.
He shall not be able to make entries at row 4 after row 3.

Please note that the number of entries will not be fixed, it will vary for user to user.

A Wb is attached which will provide more explanation and for ready testing.

Charlize
07-20-2007, 01:18 AM
?Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Offset(-1, 0).Value = vbNullString Then
ActiveCell.Offset(-1, 0).Select
End If
End Sub

sujittalukde
07-20-2007, 01:26 AM
Thanks Charlize,this is what was looking for. Its perfect.