userform not showing data on opening

[littlepete]

hello
my userform has two buttons PREVIOUS and NEXT to show data from the row before, or the row after the active cell row
but: on clicking in my data list to open the userform, it does not show anything, so now i click NEXT and then PREVIOUS and
then i get the data from the active cell row.

this is what i have:

Private Sub CommandButton13_Click()
Unload Me
ufpersonenfiche.Show ' to show the form with persons' data
End Sub

and:

Sub pfvolgendepersoon_Click() ' show next row
Dim dezerij As Long
dezerij = ActiveCell.Row + 1
volgenderij:
If Range("bl" & dezerij).Value = "x" Or Range("bl" & dezerij).Value = "o" Then ' if column BL is x/o then skip row
dezerij = dezerij + 1
GoTo volgenderij
End If
Sheets("gegevens").Range("b" & dezerij).Select
ufpersonenfiche.pfnaam.Text = Sheets("gegevens").Range("ak" & dezerij).Value
ufpersonenfiche.pfgeboorte.Text = Sheets("gegevens").Range("q" & dezerij).Value
( ...  => 39 lines to get all the data )

what should i change, to see the data from the active cell row immediately when i open the userform?

thank you for your time !!!

 

[My Aswer Is This]

To have something automatically happen when you open a UserForm you need a script like this in your Userform

Private Sub UserForm_Initialize()
'Modified  3/6/2022  10:00:49 PM  EDT
TextBox1.Value = Sheets("Alpha").Range("A1").Value
End Sub

This is the important Part:
Private Sub UserForm_Initialize()

Tells the script to run when Userform is opened
Modify other part of script to your need

 

[littlepete]

Hello

again this is something simple, but it needs to be exact... now it's working perfectly yeahhh !!!

the only thing i regret is the missing "center text in cell horizontally and vertically" but i found a trick
and i used it for my title !!!

sofar al works as it should !!! (wish i was 30 years younger so i could learn vba more hahaha)

thank you !!!