Hello Gurus,
I have an 'Update' Module that search the value of the Userform1.txt_sc.Value in Column B, but I want to search to 2 criteria, how can i amend the below code to search for 2 criteria ( userform1.txt_sc.value & userform1.txt_linenum.value )
Please Login or Register to view this content.
I haven't tested but you can try this. You didn't say if both were required so this assumes both are.
If you need to paste something offset of the second search then you need to add the .value = X2.Offset(#,#).Value's in with the ones you already have below.
Please Login or Register to view this content.
Last edited by playaller; 05-16-2014 at 04:23 PM. Reason: Updated End if Line
Shelton A.
If Helpful, Add Reputaion!
Will give this a try Shelton. Will keep you posted mate!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks