View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian[_13_] Ian[_13_] is offline
external usenet poster
 
Posts: 8
Default Searching for text or numbers in textbox


I am trying to set up a spreadsheet where I can search
for a number or a name in a two column sheet


12345 ABCDEFGH
23456 XYZABCDE
46789 EFGHIJKL
45612 ZAYBCXDV

I need to be able to search for a number and the search
gives the corresponding name and number.

Or search the name and it gives the number and name.

I would like to put the value in a textbox and the output
to be placed in a list box.

Any thoughts,

Ian,