I try to get the values from the first row to be shown in the textboxes.
The code below doesn't work. When I change End(xlDown) into Start(xlDown), it works, but gives an error. I guess "Start" is an unknown property.
Can you see where I go wrong?
ListBox1.ListIndex = 1
Dim FirstCl As Range
'first data Entry
Set FirstCl = Range("a1").End(xlDown).Offset(1, 0) 'allow for rows being added deleted above header row
.cmbAmend.Enabled = False
.cmbDelete.Enabled = False
.cmbAdd.Enabled = True
.TextBox1.Value = FirstCl.Value
.TextBox2.Value = FirstCl.Offset(0, 3).Value
.TextBox3.Value = FirstCl.Offset(0, 4).Value
.TextBox4.Value = FirstCl.Offset(0, 5).Value
.TextBox5.Value = FirstCl.Offset(0, 6).Value