I created a Userform with a listbox link to a list. When I orginally create
the userform, I use to be able to type the first letter and the listbox would
scroll to the first letter that I typed. Now it will not scroll to anything,
I have to use the mouse to get to the item in the list and if I have more
than 200 items to select from this is a pain. I Select the 0 -
fmMatchEntryFirstLetter in the ListBox Properties but it did not work!
I have tweak with every Property in the ListBox (Ithink!) but cant make it
work!
Is ther a secret or something in one of the fields in the worksheet with the
data list.

Thanks for your help!

K. Brenner

Did you try the "AutoWordSelect" = TRUE option for the listbox in th
userform?

KBrenner Wrote:
I created a Userform with a listbox link to a list. When I orginall
create
the userform, I use to be able to type the first letter and the listbo
would
scroll to the first letter that I typed. Now it will not scroll t
anything,
I have to use the mouse to get to the item in the list and if I hav
more
than 200 items to select from this is a pain. I Select the 0 -
fmMatchEntryFirstLetter in the ListBox Properties but it did not work!
I have tweak with every Property in the ListBox (Ithink!) but cant mak
it
work!
Is ther a secret or something in one of the fields in the workshee
with the
data list.

Thanks for your help!

K. Brenne

--
Ikaabo
-----------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...fo&userid=3337
View this thread: http://www.excelforum.com/showthread.php?threadid=53429

Ikaabod,
Thanks for answering!
I looked all over the properties, I still can't find it. This is a UserForm
Created in VisualBasic under InsertUserForm, then I used the Controls in
that Toolbox. I'm not really sure if all of these Toolboxes are the same??.
As a test I created a new workbook and created a ComboBox, under its
properties I did find the AutoWordSelect as you said, but none on the
UserForm ListBox.

Thanks


"Ikaabod" wrote:


Did you try the "AutoWordSelect" = TRUE option for the listbox in the
userform?

KBrenner Wrote:
I created a Userform with a listbox link to a list. When I orginally
create
the userform, I use to be able to type the first letter and the listbox
would
scroll to the first letter that I typed. Now it will not scroll to
anything,
I have to use the mouse to get to the item in the list and if I have
more
than 200 items to select from this is a pain. I Select the 0 -
fmMatchEntryFirstLetter in the ListBox Properties but it did not work!
I have tweak with every Property in the ListBox (Ithink!) but cant make
it
work!
Is ther a secret or something in one of the fields in the worksheet
with the
data list.

Thanks for your help!

K. Brenner


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=534296

My apologies. You are correct. I can't seem to recreate your problem,
and am therefore at a loss. Perhaps someone else can shed some light?
If all else fails perhaps create a new listbox and replace the old
one.

KBrenner Wrote:
Ikaabod,
Thanks for answering!
I looked all over the properties, I still can't find it. This is a
UserForm
Created in VisualBasic under InsertUserForm, then I used the Controls
in
that Toolbox. I'm not really sure if all of these Toolboxes are the
same??.
As a test I created a new workbook and created a ComboBox, under its
properties I did find the AutoWordSelect as you said, but none on the
UserForm ListBox.

Thanks


"Ikaabod" wrote:


Did you try the "AutoWordSelect" = TRUE option for the listbox in
the
userform?

KBrenner Wrote:
I created a Userform with a listbox link to a list. When I
orginally
create
the userform, I use to be able to type the first letter and the
listbox
would
scroll to the first letter that I typed. Now it will not scroll to
anything,
I have to use the mouse to get to the item in the list and if I
have
more
than 200 items to select from this is a pain. I Select the 0 -
fmMatchEntryFirstLetter in the ListBox Properties but it did not
work!
I have tweak with every Property in the ListBox (Ithink!) but cant
make
it
work!
Is ther a secret or something in one of the fields in the
worksheet
with the
data list.

Thanks for your help!

K. Brenner


--
Ikaabod

------------------------------------------------------------------------
Ikaabod's Profile:
http://www.excelforum.com/member.php...o&userid=33371
View this thread:
http://www.excelforum.com/showthread...hreadid=534296




--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=534296