View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Les Les is offline
external usenet poster
 
Posts: 240
Default Look up number entered into text box and populate another with res

Hi all,

I have a sheet "Local Parts" of part numbers in column "A" and the part
description in column "B".
I have a user form "frm_InputTM" with a text box "txt_PrtNum" where the user
will enter the part number, i then want to look up this number in the "Local
Parts" sheet and return the description and insert it in the text box
"txt_PrtDescription"

Could anybody please help me with this... thanks in advance...

--
Les