Hi,

I am currently trying to build a userform for a spreadsheet that
allows you to input data and it stores it in the appropriate w/s. I
have the add button working, however, I do not know how to code the
search button. I want to be able to put part of a name in the first
text box (txtMerchant) and then all the corresponding rows to
automatically fill with the other information. Let me know if you need
me to send the sample w/b.


Thanks!
Pramila

Hi,
Check Debra Web

http://contextures.com/xlUserForm01.html

" wrote:

Hi,

I am currently trying to build a userform for a spreadsheet that
allows you to input data and it stores it in the appropriate w/s. I
have the add button working, however, I do not know how to code the
search button. I want to be able to put part of a name in the first
text box (txtMerchant) and then all the corresponding rows to
automatically fill with the other information. Let me know if you need
me to send the sample w/b.


Thanks!
Pramila