Using Vlookup in Excel
Is there a way to have a lookup value displayed when you starting typing the
first couple of letters of the value in the box? Also, I would like to have a calendar in a drop-down to select a date by simply clicking on the date. Can this be done in excel? |
Using Vlookup in Excel
ToolsAutocorrect options
-- Kind regards, Niek Otten "JimD" wrote in message ... Is there a way to have a lookup value displayed when you starting typing the first couple of letters of the value in the box? Also, I would like to have a calendar in a drop-down to select a date by simply clicking on the date. Can this be done in excel? |
Using Vlookup in Excel
Jim
Yes to both. See Debra Dalgleish's site for instructions on building a Data Validation with combined ComboBox which has AutoText. http://www.contextures.on.ca/xlDataVal10.html See Ron de Bruin's site for a Calendar drop-down. http://www.rondebruin.nl/calendar.htm Gord Dibben Excel MVP On Tue, 20 Dec 2005 11:02:04 -0800, "JimD" wrote: Is there a way to have a lookup value displayed when you starting typing the first couple of letters of the value in the box? Also, I would like to have a calendar in a drop-down to select a date by simply clicking on the date. Can this be done in excel? |
All times are GMT +1. The time now is 11:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com