If match found then show only one msgbox with multiple textboxes

[HaroonSid]

hi,
i am using below code if value match then appears a msgbox to ignore the duplicate entries
it works with
textbox31, textbox32, textbox33, textbox34, textbox35, textbox36
if above textboxes value match with Worksheets("RATE").Range("Q2:Q" & Worksheets("RATE").Cells(Rows.Count, "Q").End(xlUp).Row
then
its shows a msgbox("NAME ALREADY ADDED")

if all textboxes value found in range Q2:Q then its shows 6 time msgbox
while
i need only one msgbox to show the msg if any textbox value match with Q2:Q

Please Login or Register  to view this content.

[bakerman2]

This will get you started.

Please Login or Register  to view this content.

[HaroonSid]

Super duper perfect

awesome bakerman2


thank you very very much


its working perfectly as i need

[bakerman2]

You're welcome and thanks for rep+.