list boxes - multiple row sources?

[themangostays]

Hi,

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


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

Help greatly appreciated.!

Cheers

Adam

(e-mail address removed)

 

[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]...