View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Moh Moh is offline
external usenet poster
 
Posts: 58
Default userform to search by entering data into a textbox

Hello i have a sheet with data in column A and column B

Is there a way in creating a userform that will let me type in data in a
textbox (from column a) that will bring up information from column b

e.g A1 WILL BE LINKED TO B1
A2 WILL BE LINKED TO B2
A3 WILL BE LINKED TO B3 etc.....
so i type in a word from the column A e.g Business Department then it will
bring up a telephone Number for that Business Department from column B.

Thanks
--
please can you help... its urgent