jumping to a portion of a list box

[rebecca mann]

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

[Chip Pearson]

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" <[email protected]> wrote in message
news:%[email protected]...
>
>
> 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 ***

[Tom Ogilvy]

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" <[email protected]> wrote in message
news:%[email protected]...
>
>
> 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 ***