list boxes - multiple row sources?
 

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



--
themangostay
-----------------------------------------------------------------------
themangostays's Profile: http://www.excelforum.com/member.php...fo&userid=3187
View this thread: http://www.excelforum.com/showthread.php?threadid=51608

list boxes - multiple row sources?
 

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

list boxes - multiple row sources?
 

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"
wrote in message
news:themangostays.23pwqm_1140757800.9376@excelfor um-nospam.com...

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




--
themangostays
------------------------------------------------------------------------
themangostays's Profile:
http://www.excelforum.com/member.php...o&userid=31879
View this thread: http://www.excelforum.com/showthread...hreadid=516083