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 ***

How would any possible code determine what location to jump to?

A listbox has TopIndex property that specifies the list entry
that is to be displayed at the top of the listbox, but you have
to know that index number.

Me.ListBox1.TopIndex = 1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"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 ***

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 ***