View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default jumping to a portion of a list box

If your using Excel (rather than pocket excel), then you can use a combox
from the control toolbar toolbox and set it to match based on the characters
typed in.

Otherwise, you might have multiple picklists with sections of the original
list.

--
Regards,
Tom Ogilvy

"rebecca mann" wrote in message
...


Greetings all, I am developing a workbook for data collection in a
research project (which will be used from a PDA). We are tracking plant
species that occur at a particular site and I have a picklist from which
the user can choose one plant among about 200 that could potentially
occur at the site. However, using this picklist on the PDA is
cumbersome: the user has to scroll down the list by pointing the little
stylus into the littler cell on the screen... this really slows down
the data collection process. Is there a way to jump to a portion of the
picklist instead, or does anyone have a creative idea as to how we might
solve this probem?

Thanks - I'll be glad for any advice!!

*** Sent via Developersdex http://www.developersdex.com ***