genracela
05-20-2010, 05:40 PM
I've been addicted to VBA since joining this forum.
I already learned how to write VBA codes for my formulas and calculations, lookup from 1 workbook to another then copy paste data, cell splitting etc etc...
And right now I'm into using userform.
I have a file(attached), an I want to do an autofilter using VBA. I already put my userform, but the problem is, I don't know how to start the idea that I have in mind.
In the userform, I want to type in the search criteria(criterias on B6="code"), then it will just automatically filter if I click on the "SEARCH BUTTON", then Clear the UserForm(not the data) when I click on "Clear"
Thanks!
I already learned how to write VBA codes for my formulas and calculations, lookup from 1 workbook to another then copy paste data, cell splitting etc etc...
And right now I'm into using userform.
I have a file(attached), an I want to do an autofilter using VBA. I already put my userform, but the problem is, I don't know how to start the idea that I have in mind.
In the userform, I want to type in the search criteria(criterias on B6="code"), then it will just automatically filter if I click on the "SEARCH BUTTON", then Clear the UserForm(not the data) when I click on "Clear"
Thanks!