I learnt from my previous post to write a matching code.
but now , if the matching fails, I want to add a msgbox to alert and the excel stuck.
it seems that I did not wrote the right sentence.
so if I want to alert that no matching was found, how this sentence should be in the "if"
see my below wrong code.
thks.Capture.JPG1.JPG
I am not completely sure what you are asking, if you move the msgbox after the "Next d" , it will pop up after the loop.
You may have to supply a sample workbook, instead of a picture, hard to work with a picture.
moveHere.jpg
Hi,
I have attached the excel.
if the model# does not match the model# in sheet(4) & sheet(5) then there will be a masgbox to tell that "no match'
but now when I add the magbox into the code, the excel stuck
so something must be wrong, but I dun know.
could you pls help me to check?
thks.
Last edited by VBAidot; 08-22-2016 at 04:25 AM.
Move the msgbox line and search the correct column, your workbook has you looping column "C"
Please Login or Register to view this content.
Hi,
thks for ur reply.
I have tried your modified code, but when there is a match found as shown in the below pic, it also poped up the msgbox, which will only be poped up
when there is no mathch found.
besides, I have to click twice to let the magbox disappear.
could you pls help me to check again?
thks
Attachment 476737
Try this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thanks for adding rep points.
Suppose it's working now?
Hi bakerman2,
yes, it's working well.
thks.
Hi Bakerman,
if it needs to meet
1) sheets(2).textbox2. value match sheets(i).column(4).value
and
2) sheets(2).textbox1. value match sheets(i).column(3).value
then copy the info
I tried the match function but there was an error showed "object doesn't support this property or method"
so if it needs to meet 2 conditions , then the match function can't use?
thks.
Sorry for delay in response.Been a bit busy lately.
Try following.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks