software

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?

Toolsgt;Autocorrect options

--
Kind regards,

Niek Otten

quot;JimDquot; gt; wrote in message
...
gt; Is there a way to have a lookup value displayed when you starting typing
gt; the
gt; first couple of letters of the value in the box?
gt;
gt; Also, I would like to have a calendar in a drop-down to select a date by
gt; simply clicking on the date. Can this be done in excel?
Jim

Yes to both.

See Debra Dalgleish's site for instructions on building a Data Validation with
combined ComboBox which has AutoText.

www.contextures.on.ca/xlDataVal10.html

See Ron de Bruin's site for a Calendar drop-down.

www.rondebruin.nl/calendar.htmGord Dibben Excel MVP

On Tue, 20 Dec 2005 11:02:04 -0800, quot;JimDquot; gt;
wrote:

gt;Is there a way to have a lookup value displayed when you starting typing the
gt;first couple of letters of the value in the box?
gt;
gt;Also, I would like to have a calendar in a drop-down to select a date by
gt;simply clicking on the date. Can this be done in excel?