View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BrianMo BrianMo is offline
external usenet poster
 
Posts: 17
Default Shortcuts for a listbox selection

In excel 2003 professional I have a spreadsheet that is going to be used by
several employees that has drop down lists associated with it for the amount
of hours worked. The problem I am incurring is several of the employees do
not like to have to scroll through a list of values and prefer to type in one
digit and have the box recognize that and put that response in. Is there any
way I can get this to work in excel. For example on of the employees wants
to imput 315 and rather than scroll down to 315 they want to be able to hit
315 and the list go right to it or close to it.