To select the next row down from where you a

Sub OneRowDown()
ActiveCell.Offset(1, 0).EntireRow.Select
End Sub
--
Gary''s Student - gsnu200845


"Bob" wrote:

I have a userform with several textboxes which I fill in data and save to a
data sheet. It also has a search facility by inserting a date in textbox1 and
pressing a commandbutton, it brings up data from that row.
I am trying to find a way to select the next row up or down and have the
data display. So that I can select a date and have the data displayed then go
up or down the rows from that date.
--
Bob