Hi All,
The below code populates the text boxes within my userform by selecting a row in the listbox,
The only issue I am having with this is a number of the 32 textboxes contain dates that are being formatted into numbers rather than dd/mm/yyyy,
Is anyone able to apply this to the code below please I have tried myself to no avail,
Many Thanks
The below code populates the text boxes within my userform by selecting a row in the listbox,
The only issue I am having with this is a number of the 32 textboxes contain dates that are being formatted into numbers rather than dd/mm/yyyy,
Is anyone able to apply this to the code below please I have tried myself to no avail,
Many Thanks
VBA Code:
Private Sub ListBox1_Click()
Dim i As Integer
'Loads textboxes with selected listbox values
For i = 1 To 32
Nameinput.Controls("TextBox" & i).Value = Nameinput.ListBox1.List(, i - 1)
Next i
End Sub