Return date format in userform textbox

Originally Posted by torachan

I have run through your code to demonstrate how little coding you need if using 'proper tables'.
Also in your particular app there is no need for a search routine - there is a direct link between the listindex and the table row.

Hi tora,

How do I link myForm to userform1?
Because I'm getting error, subcript out of range.
I've changed the table reference from table1 to table13

The commandbutton (Index) in myForm

Private Sub CommandButton10_Click()
Me.Hide
UserForm1.Show
Me.Show

End Sub

Should be as simple as that right?
Where am I doing wrong?