Hi Experts,
I am Preparing a Userform with text boxes inorder to filter a huge data(nearly 100000 lines) I have given following code In Command Button )
Private Sub CommandButton2_Click()
Sheets("sheet3").Select
Selection.AutoFilter Field:=4, Criteria1:="=*" & TextBox1.Text & "*", Operator:=xlAnd
End sub
I have never created the userforms before this is first time.The code which I have mentioned above doesnot work as per my need.though it filters it doesnot select all the data in the sheet out of 100000 lines it selects only 70000 lines and in task bar it shows as 70000 of 100000 lines selected but if I manually filter all the 100000 lines will be selected and the data in excel sheet are almost in same format only values differ . I am trying from almost a week to correct it but fialed.Can anyone help me with this.I need to submit this project today to my manager.
I am Preparing a Userform with text boxes inorder to filter a huge data(nearly 100000 lines) I have given following code In Command Button )
Private Sub CommandButton2_Click()
Sheets("sheet3").Select
Selection.AutoFilter Field:=4, Criteria1:="=*" & TextBox1.Text & "*", Operator:=xlAnd
End sub
I have never created the userforms before this is first time.The code which I have mentioned above doesnot work as per my need.though it filters it doesnot select all the data in the sheet out of 100000 lines it selects only 70000 lines and in task bar it shows as 70000 of 100000 lines selected but if I manually filter all the 100000 lines will be selected and the data in excel sheet are almost in same format only values differ . I am trying from almost a week to correct it but fialed.Can anyone help me with this.I need to submit this project today to my manager.
