|
User Form will not scroll to Match Entry First Letter?
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 |
User Form will not scroll to Match Entry First Letter?
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 |
User Form will not scroll to Match Entry First Letter?
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 |
User Form will not scroll to Match Entry First Letter?
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 |
| All times are GMT +1. The time now is 01:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com