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

Set the TextColumn value to 1
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Franky27" wrote:

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