F
Franky27
I have a listbox with the following properties
BoundColumn 1
ColumnCount 2
ColumnHeads True
RowSource Sheet1!A2:B5
On sheet1 I have
nr item
11 A
12 B
13 C
14 D
15 E
When I select in my listbox for example nr 13 and I submit my form te
result is 13 (so that's ok)
But there are 2 things I don't know how to manage.
1. When I select nr 13 in the listbox it shows in my userform nr 3 (the
rownumber I think) I want to see nr 13
2. When I tyoe in the listbox for example 15, I want the listbox to jump to
15 so don't have to click nr 15
Thanks
BoundColumn 1
ColumnCount 2
ColumnHeads True
RowSource Sheet1!A2:B5
On sheet1 I have
nr item
11 A
12 B
13 C
14 D
15 E
When I select in my listbox for example nr 13 and I submit my form te
result is 13 (so that's ok)
But there are 2 things I don't know how to manage.
1. When I select nr 13 in the listbox it shows in my userform nr 3 (the
rownumber I think) I want to see nr 13
2. When I tyoe in the listbox for example 15, I want the listbox to jump to
15 so don't have to click nr 15
Thanks