M
Martin Beir
I have placed a listbox on a userform and filled it using the "additem"
method. When I display the form and attempt to select from the list by
pressing a key the result is consistently inaccurate. If I key an "s" then
the first item beginning with t is selected, key "a" selects b, key "b"
selects c, etc. This strange behaviour occurs regardless of whether the list
is displayed alphabetically or randomly.
The above is specific to a listbox on a userform. A list box placed on a
dialogsheet (it is still possible to insert dialogsheets using VBA) behaves
correctly and of course I have the advantage of being able to describe the
list as an imput range and not having to wait (zzzzzz) while the listbox is
loading.
Any answers?
method. When I display the form and attempt to select from the list by
pressing a key the result is consistently inaccurate. If I key an "s" then
the first item beginning with t is selected, key "a" selects b, key "b"
selects c, etc. This strange behaviour occurs regardless of whether the list
is displayed alphabetically or randomly.
The above is specific to a listbox on a userform. A list box placed on a
dialogsheet (it is still possible to insert dialogsheets using VBA) behaves
correctly and of course I have the advantage of being able to describe the
list as an imput range and not having to wait (zzzzzz) while the listbox is
loading.
Any answers?