Hi all
I have workbook with form to type value, form have 02 textbox.
If textbox1 = "" then Exit Sub
This value use to find in column(A) in 02 sheet(array("nb","ngb"))
If condition is meet with Textbox1 then copy that row to sheet(ky1), if meet with Textbox2 then copy that row to sheet(ky2)
For examble: Textbox1 I type: "aaaaa001-201908" or only type: "aaaa001" => If column A in sheet(nb), sheet(ngb) are meet then copy that row to sheet(ky1).
My code below have mistake at line: Type Miss match - error "13"
ans1 = UserForms(CDKT).TextBox1.Value
ans2 = UserForms(CDKT).TextBox2.Value
Please see at my attachment to clear my idea. Thanks./.
Bookmarks