Search button on an USERFORM

[alopecito]

HI there, I've been working in a project for my company, I have been receiving so much help from this forum, is amazing how people can be so kind!..I'm stuck again and I decided to ask again for some help, my code is working find but I need to have a search button, basically if you see the attachments you will found an excel file with a User-form on it, I use that to run a mail merge, I need to be able to search the excel spreadsheet and find info already in, populate that in my user-form and finally be able to send it back to the excel, all is OK but my search button is not, I'm not an expert, I used a code I found in another thread..If someone can help will be much appreciate it!

[JBeaucaire]

A little more basic approach to "setting a range" then using one of the properties of the found range. In this instance we set the range then use the .Row property to grab data from that row in specific columns.

Please Login or Register  to view this content.

[alopecito]

Thanks for the Code, works perfectly!!!..Problem solved!