Filtering a list Box, URGENT

[Chris]

Hi,

Please someone HELP! I have a giant list, but it can't
take up much room so I have it in a list box. I want to
know how I can filter the List box when someone enters in
a number. The list has multiple columns, but I can't get
anywhere.

Ex. (so when they enter in the ORG ID I want it to filter
the lists below that, any ideas. Help!)

Org ID: xxxxx

Equipment Acq Date Cost NBV

xxxxxxx xxxxxx xxxxx xxxxx
xxxxxxx xxxxxx xxxxx xxxxx
xxxxxxx xxxxxx xxxxx xxxxx

 

[Frank Kabel]

Hi
why not use 'Data - Filter - Autofilter'

 

[Nick Hodge]

Chris

I'm not sure about the list box reference but can you not put it in a sheet
and use either Data>autofilter or Data>advanced filter...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Guest]

but if the people enter in their ORG ID then I want to try
and have all the Equipment, Act Dt, Cost, and NBV change
along with the ORG ID, because it is all different
compared to what ID number you enter.