Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 114
Default autofilling a cell as the user types

Hi,

From memory I seem to recall that if you use a list to validate the
data in a dropdown box, as the user types, the entry automatically
fills, so the user can press tab when the correct data is visible.
How can I do this in a normal cell? To clarify, I have a named range
which I use as a list to validate the input of a cell. This named
range consists of staff names. As the user types, I want the name to
start to populate in the cell, as this will be quicker than selecting
the name from a long list in the dropdown list of the validated cell.
Can I have the cell autofill/populate like this?

Hope you can help...
Matt
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default autofilling a cell as the user types

If you create the dropdown list and define (name) the range as you describe
in the past it will work. The user can just ignore the dropdown arrow and
start typing in the cell. Once the user starts typing in the cell it will
autopopulate. The catch is that the user typing their name in a cell has to
achieve a unique combination before the correct name will appear. For
example if you have and Employee name Steve and one Named Stewart, Stewart
will have to type in STEW before the correct name would autopopulate.

"MJKelly" wrote:

Hi,

From memory I seem to recall that if you use a list to validate the
data in a dropdown box, as the user types, the entry automatically
fills, so the user can press tab when the correct data is visible.
How can I do this in a normal cell? To clarify, I have a named range
which I use as a list to validate the input of a cell. This named
range consists of staff names. As the user types, I want the name to
start to populate in the cell, as this will be quicker than selecting
the name from a long list in the dropdown list of the validated cell.
Can I have the cell autofill/populate like this?

Hope you can help...
Matt

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reset a User Defined Types Values RyanH Excel Programming 7 November 19th 08 10:57 PM
User Defined Types and Overloaded Operators eq Excel Programming 4 November 22nd 07 07:40 PM
Checking user defined types for Nothing jayklmno Excel Programming 5 May 3rd 06 09:21 PM
User-defined data type; Error: Only User-defined types... tiger_PRM Excel Programming 1 July 18th 04 03:32 PM


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"