|
Select from drop down list via typing text?
I'd like to save time selecting from a drop down list by typing the first few
letters of textl and have the cell "auto fill." |
Select from drop down list via typing text?
If you are using a combobox from the controls menu, set the
AutoWordSelect property to True. If you are using a data validation dropdown, you can't do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Excel Novice" <Excel wrote in message ... I'd like to save time selecting from a drop down list by typing the first few letters of textl and have the cell "auto fill." |
Select from drop down list via typing text?
Chip,
I am also interested in doing this. Is there a good tutorial on setting up a combobox from the controls menu so that the user can just type some text to select an entry? Phil. "Chip Pearson" wrote: If you are using a combobox from the controls menu, set the AutoWordSelect property to True. If you are using a data validation dropdown, you can't do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Excel Novice" <Excel wrote in message ... I'd like to save time selecting from a drop down list by typing the first few letters of textl and have the cell "auto fill." |
Select from drop down list via typing text?
Phil
Should be all you need at Debra Dalgleish's site. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Mon, 12 Jun 2006 07:57:02 -0700, Phil wrote: Chip, I am also interested in doing this. Is there a good tutorial on setting up a combobox from the controls menu so that the user can just type some text to select an entry? Phil. "Chip Pearson" wrote: If you are using a combobox from the controls menu, set the AutoWordSelect property to True. If you are using a data validation dropdown, you can't do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Excel Novice" <Excel wrote in message ... I'd like to save time selecting from a drop down list by typing the first few letters of textl and have the cell "auto fill." |
Select from drop down list via typing text?
Hi Gord,
I referenced the site you recommended and found it helpful. Unfortunately, I can not get the combo box to reference the drop down list - it pops up empty. I am curious whether the macro code needs modification because I am linking validation list from another workbook. I do have it open when attempting to execute. Any recommendations would be greatly appreciated. Thanks, Jim "Gord Dibben" wrote: Phil Should be all you need at Debra Dalgleish's site. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Mon, 12 Jun 2006 07:57:02 -0700, Phil wrote: Chip, I am also interested in doing this. Is there a good tutorial on setting up a combobox from the controls menu so that the user can just type some text to select an entry? Phil. "Chip Pearson" wrote: If you are using a combobox from the controls menu, set the AutoWordSelect property to True. If you are using a data validation dropdown, you can't do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Excel Novice" <Excel wrote in message ... I'd like to save time selecting from a drop down list by typing the first few letters of textl and have the cell "auto fill." |
Select from drop down list via typing text?
Did you first create the Data Validation dropdowns as instructed?
Since you're using another workbook for the source, make sure you use a named range from that workbook as your list source. http://www.contextures.on.ca/xlDataVal05.html A sample workbook can be found at Debra's site http://www.contextures.on.ca/excelfiles.html#DataVal DV0028 - Data Validation Combobox Named Lists -- Double-click a cell that contains a data validation list, and a combobox appears -- font size can be set, more than 8 rows displayed, autocomplete can be enabled. Lists are stored in named ranges on a separate sheet. Macros must be enabled. DataValComboboxSheet.zip 13 kb updated 15-Jan-07 View detailed Instructions Another one from same site............. DV0043 - Data Validation Combobox With Entry Check -- Double-click a cell that contains a data validation list, and a combobox appears -- font size can be set, more than 8 rows displayed, autocomplete can be enabled. When the combobox loses focus, the entry is validated. DataValComboCheck.zip 15 kb 29-Jun-06 Updated 11-Oct-06 Gord On Tue, 9 Sep 2008 20:06:01 -0700, Jim wrote: Hi Gord, I referenced the site you recommended and found it helpful. Unfortunately, I can not get the combo box to reference the drop down list - it pops up empty. I am curious whether the macro code needs modification because I am linking validation list from another workbook. I do have it open when attempting to execute. Any recommendations would be greatly appreciated. Thanks, Jim "Gord Dibben" wrote: Phil Should be all you need at Debra Dalgleish's site. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Mon, 12 Jun 2006 07:57:02 -0700, Phil wrote: Chip, I am also interested in doing this. Is there a good tutorial on setting up a combobox from the controls menu so that the user can just type some text to select an entry? Phil. "Chip Pearson" wrote: If you are using a combobox from the controls menu, set the AutoWordSelect property to True. If you are using a data validation dropdown, you can't do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Excel Novice" <Excel wrote in message ... I'd like to save time selecting from a drop down list by typing the first few letters of textl and have the cell "auto fill." |
Select from drop down list via typing text?
I found this thread to be very helpful, but i just have one more question.
I've set everything up according the instructions on the ConTextures Page and it works great. Now my problem is, if there is a typo instead of matching the entry to one on the validation list it just pastes the mispelled word in the selected cell. Is there a way to modify the code to give an error message if the entry doesn't match one in the validation list? Any help given is greatly appreciated. Thanks "Gord Dibben" wrote: Did you first create the Data Validation dropdowns as instructed? Since you're using another workbook for the source, make sure you use a named range from that workbook as your list source. http://www.contextures.on.ca/xlDataVal05.html A sample workbook can be found at Debra's site http://www.contextures.on.ca/excelfiles.html#DataVal DV0028 - Data Validation Combobox Named Lists -- Double-click a cell that contains a data validation list, and a combobox appears -- font size can be set, more than 8 rows displayed, autocomplete can be enabled. Lists are stored in named ranges on a separate sheet. Macros must be enabled. DataValComboboxSheet.zip 13 kb updated 15-Jan-07 View detailed Instructions Another one from same site............. DV0043 - Data Validation Combobox With Entry Check -- Double-click a cell that contains a data validation list, and a combobox appears -- font size can be set, more than 8 rows displayed, autocomplete can be enabled. When the combobox loses focus, the entry is validated. DataValComboCheck.zip 15 kb 29-Jun-06 Updated 11-Oct-06 Gord On Tue, 9 Sep 2008 20:06:01 -0700, Jim wrote: Hi Gord, I referenced the site you recommended and found it helpful. Unfortunately, I can not get the combo box to reference the drop down list - it pops up empty. I am curious whether the macro code needs modification because I am linking validation list from another workbook. I do have it open when attempting to execute. Any recommendations would be greatly appreciated. Thanks, Jim "Gord Dibben" wrote: Phil Should be all you need at Debra Dalgleish's site. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Mon, 12 Jun 2006 07:57:02 -0700, Phil wrote: Chip, I am also interested in doing this. Is there a good tutorial on setting up a combobox from the controls menu so that the user can just type some text to select an entry? Phil. "Chip Pearson" wrote: If you are using a combobox from the controls menu, set the AutoWordSelect property to True. If you are using a data validation dropdown, you can't do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Excel Novice" <Excel wrote in message ... I'd like to save time selecting from a drop down list by typing the first few letters of textl and have the cell "auto fill." |
Select from drop down list via typing text?
Hi Gord,
Thanks much for your follow up and advice. Yes, I have followed your instruction with validation source. I am now experiencing another prblm in that I can not get the combo box to activate on double click with the provided code from DD. I have taken initial source files v1.1 and tried to reinitiate the instruction without success. I am at a loss and don't expect for you to waste time, unless you think of another oversight on my part. Thanks and Best, Jim "Gord Dibben" wrote: Did you first create the Data Validation dropdowns as instructed? Since you're using another workbook for the source, make sure you use a named range from that workbook as your list source. http://www.contextures.on.ca/xlDataVal05.html A sample workbook can be found at Debra's site http://www.contextures.on.ca/excelfiles.html#DataVal DV0028 - Data Validation Combobox Named Lists -- Double-click a cell that contains a data validation list, and a combobox appears -- font size can be set, more than 8 rows displayed, autocomplete can be enabled. Lists are stored in named ranges on a separate sheet. Macros must be enabled. DataValComboboxSheet.zip 13 kb updated 15-Jan-07 View detailed Instructions Another one from same site............. DV0043 - Data Validation Combobox With Entry Check -- Double-click a cell that contains a data validation list, and a combobox appears -- font size can be set, more than 8 rows displayed, autocomplete can be enabled. When the combobox loses focus, the entry is validated. DataValComboCheck.zip 15 kb 29-Jun-06 Updated 11-Oct-06 Gord On Tue, 9 Sep 2008 20:06:01 -0700, Jim wrote: Hi Gord, I referenced the site you recommended and found it helpful. Unfortunately, I can not get the combo box to reference the drop down list - it pops up empty. I am curious whether the macro code needs modification because I am linking validation list from another workbook. I do have it open when attempting to execute. Any recommendations would be greatly appreciated. Thanks, Jim "Gord Dibben" wrote: Phil Should be all you need at Debra Dalgleish's site. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Mon, 12 Jun 2006 07:57:02 -0700, Phil wrote: Chip, I am also interested in doing this. Is there a good tutorial on setting up a combobox from the controls menu so that the user can just type some text to select an entry? Phil. "Chip Pearson" wrote: If you are using a combobox from the controls menu, set the AutoWordSelect property to True. If you are using a data validation dropdown, you can't do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Excel Novice" <Excel wrote in message ... I'd like to save time selecting from a drop down list by typing the first few letters of textl and have the cell "auto fill." |
Select from drop down list via typing text?
When you downloaded one of the sample workbooks from Debra's site did it
work as you expected? If so, you should be able to adjust your own workbook to do the same. You have seemingly missed a step or two in the process or you are looking for something other than what Debra's sample workbooks provide. Gord On Wed, 10 Sep 2008 19:33:01 -0700, Jim wrote: Hi Gord, Thanks much for your follow up and advice. Yes, I have followed your instruction with validation source. I am now experiencing another prblm in that I can not get the combo box to activate on double click with the provided code from DD. I have taken initial source files v1.1 and tried to reinitiate the instruction without success. I am at a loss and don't expect for you to waste time, unless you think of another oversight on my part. Thanks and Best, Jim "Gord Dibben" wrote: Did you first create the Data Validation dropdowns as instructed? Since you're using another workbook for the source, make sure you use a named range from that workbook as your list source. http://www.contextures.on.ca/xlDataVal05.html A sample workbook can be found at Debra's site http://www.contextures.on.ca/excelfiles.html#DataVal DV0028 - Data Validation Combobox Named Lists -- Double-click a cell that contains a data validation list, and a combobox appears -- font size can be set, more than 8 rows displayed, autocomplete can be enabled. Lists are stored in named ranges on a separate sheet. Macros must be enabled. DataValComboboxSheet.zip 13 kb updated 15-Jan-07 View detailed Instructions Another one from same site............. DV0043 - Data Validation Combobox With Entry Check -- Double-click a cell that contains a data validation list, and a combobox appears -- font size can be set, more than 8 rows displayed, autocomplete can be enabled. When the combobox loses focus, the entry is validated. DataValComboCheck.zip 15 kb 29-Jun-06 Updated 11-Oct-06 Gord On Tue, 9 Sep 2008 20:06:01 -0700, Jim wrote: Hi Gord, I referenced the site you recommended and found it helpful. Unfortunately, I can not get the combo box to reference the drop down list - it pops up empty. I am curious whether the macro code needs modification because I am linking validation list from another workbook. I do have it open when attempting to execute. Any recommendations would be greatly appreciated. Thanks, Jim "Gord Dibben" wrote: Phil Should be all you need at Debra Dalgleish's site. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Mon, 12 Jun 2006 07:57:02 -0700, Phil wrote: Chip, I am also interested in doing this. Is there a good tutorial on setting up a combobox from the controls menu so that the user can just type some text to select an entry? Phil. "Chip Pearson" wrote: If you are using a combobox from the controls menu, set the AutoWordSelect property to True. If you are using a data validation dropdown, you can't do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Excel Novice" <Excel wrote in message ... I'd like to save time selecting from a drop down list by typing the first few letters of textl and have the cell "auto fill." |
| All times are GMT +1. The time now is 04:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com