userform button next/previous works only one time !

[littlepete]

hello all

i'm putting a NEXT and PREVIOUS button on my userform to see other data (from other rows) ...

strangely they work only once, and i think why: the activecell.row is stored in a variable, but in the datalist the active cell
remains on the same row.

how can i change my code to make it work?

Sub pfvolgendepersoon_Click() ' sub next person
Dim dezerij As Long ' dezerij = this row
dezerij = ActiveCell.Row + 1
Sheets("gegevens").Range("b" & ActiveCell.Row).Select
ufpersonenfiche.pfnaam.Text = Sheets("gegevens").Range("ak" & dezerij).Value ' copying data from list to u.f.
... ( and so 30 more)

 

[rlv01]

Maybe this instead:

    Sheets("gegevens").Range("b" & dezerij).Select

 

[littlepete]

wow ...

that i should have seen have asleep even !!! lol thank you so much the creative mind can continue now

have a great sunday !!!

 

[rlv01]

We all experience brain lock-up from time to time