macro to display a msgbox

Hi all,

i need a help to display a msgbox if the condition used for search is wrong .the msg box should display a message as"wrong entry try again" with a retry button in it.
pl refer the attached xls file.
the existing is a result of search for 'x'' done if its wrong it has to display the error msg.
pl run the macro to get an idea about the search.

Thanks
sanyaa

Please Login or Register  to view this content.

Hi,

It worked on displaying the message box.May I please know which line of the above code states about the selection of the data range in Release record for search.My actual data sheet has 9000+ rows of data .so when i searched for a data from row 3000+ its showed the message "try again" .Please educate on the code error.

Thanks in advance.
sanyaa

Use Debug.Print to find search ranges. After running, look in the Immediate window for debug.print output.

Note that you might want to use a UsedRange rather than CurrentRegion as the latter stops at the first blank row.

Please Login or Register  to view this content.

Hi Kenneth,
Thanks for your input.It worked.My xls file had blank rows inbetween clearing that it worked with current region.

Thanks a lot.
sanyaa