GhostofDoom
12-07-2019, 02:35 AM
Hello,
i was wondering if it can be done to search with 2 string?
Set findvalue = Sheet3.Range("B9"), Range("C1000000").Find(What:=Label5.Caption, Label6.Caption, LookIn:=xlValues, LookAt:=xlWhole)
this doesn't seems working
we have in our sheet Lastname Firstname Column
when i select the JOHN DOE from the combobox
i split it in 2 string
and like to find those 2 string on Lastname Firstname columns on the sheet
to change some values for this customer
i have really no idea how to search for a customer if those are split in the sheet
will be awesome if we can get from the sheet3 the lastname firstname and search if the match from the combobox
Thanks.
i was wondering if it can be done to search with 2 string?
Set findvalue = Sheet3.Range("B9"), Range("C1000000").Find(What:=Label5.Caption, Label6.Caption, LookIn:=xlValues, LookAt:=xlWhole)
this doesn't seems working
we have in our sheet Lastname Firstname Column
when i select the JOHN DOE from the combobox
i split it in 2 string
and like to find those 2 string on Lastname Firstname columns on the sheet
to change some values for this customer
i have really no idea how to search for a customer if those are split in the sheet
will be awesome if we can get from the sheet3 the lastname firstname and search if the match from the combobox
Thanks.