list boxes - multiple row sources?

[themangostays]

Hi,

Im new to the world and headaches of excel VBA, just wondering what the syntax is for multiple row selection in the row source property of a list box (for a form) ? any help would be greatly appreciated...


Even better, what I'm trying to acheive is effectivly text box filter that will reduce the content (from everything) of a list box. The fields I want are client number (xxx), client name (first) and client name (second). As the user types in the first letters of these three fields the contents of the list box reduce to the point where only one selection remains. The data source for these fields are three rows in a sheet.

Help greatly appreciated.!

Cheers

Adam

[email protected]

[dmexcel]

Hi Adam,
Do a search in your excel forum, or search contextures web page and
look for dependent dropdown lists, I thinks that may help you out

[Tom Ogilvy]

Closest built in capability I could think of is a Combobox on a userform
where you set the MatchEntry property to FmMatchEntryComplete

This doesn't reduce the list, but moves through a sorted list

Otherwise you would have to program the functionality and would not be able
to use RowSource, but need to use AddItem, clearing and rebuilding the list
on each keystroke.

--
Regards,
Tom Ogilvy



"themangostays" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi,
>
> Im new to the world and headaches of excel VBA, just wondering what the
> syntax is for multiple row selection in the row source property of a
> list box (for a form) ? any help would be greatly appreciated...
>
>
> Even better, what I'm trying to acheive is effectivly text box filter
> that will reduce the content (from everything) of a list box. The
> fields I want are client number (xxx), client name (first) and client
> name (second). As the user types in the first letters of these three
> fields the contents of the list box reduce to the point where only one
> selection remains. The data source for these fields are three rows in a
> sheet.
>
> Help greatly appreciated.!
>
> Cheers
>
> Adam
>
> [email protected]
>
>
> --
> themangostays
> ------------------------------------------------------------------------
> themangostays's Profile:
http://www.excelforum.com/member.php...o&userid=31879
> View this thread: http://www.excelforum.com/showthread...hreadid=516083
>