Tags Tags

Need VB formula to retrieve data

December 22nd, 2011 - 05:25 pm ET by dave | Report spam
Help Create a new topic
Hello,

I need help here. I need the VB formula to retrieve data from sheet to
text box in form. Data in sheet 1 A1:E1. When type the part number in
text box and press search, I need bring all the relevant information
the into the text that located in form.

Please help

Thanks

Dave
email Follow the discussionReplies 19 repliesReplies Make a reply

Replies

#1 isabelle
December 22nd, 2011 - 09:42 pm ET | Report spam
hi Dave,

if the value to search is to be found in column A and the relevant information to be find
in columns B:E you can use the combination of INDEX and MATCH function,
but you did not say where to put the result.
in which control ?


isabelle



Le 2011-12-22 17:25, dave a écrit :
Hello,

I need help here. I need the VB formula to retrieve data from sheet to
text box in form. Data in sheet 1 A1:E1. When type the part number in
text box and press search, I need bring all the relevant information
the into the text that located in form.

Please help

Thanks

Dave

Similar topics

Make your own search :