Input Box prompts Message Box

Hi,

I am writing some (fairly basic) code where a user inputs a number to an input box which is then copied to a cell but I am trying to add a little extra functionality whereby if the value input results in an error i.e. the details related to that number are 'not found' (by a vlookup with an if in a different cell) then an message box is displayed with "Not Found". I've had a bash with little success but I think it's mainly because I don't know where to place the lines in my code.

Hope you can help.

Thanks

Please Login or Register  to view this content.

Do you have to compare your inputbox value to just 1 cell or multiple cells?

So you mean that if the value provided by the user in the inputbox does not match A17, a message box should be displayed?

I am probably not explaining it well, sorry!

A user inputs a number via the Input Box which is then put into cell E5. There is then a VLookup from that cell value to display related data in other cells. What I want to do is where the Vlookup returns a #N/A (though I've used IFERROR so it would return "Not Found") a message box is displayed stating "Not Found". Hope that makes sense.

Only other situation is that where the user enters nothing by just clicking ok (with out type in a number) or clicks cancel, I want cell E5 to be blank, hence the IF strSearch = "".

Thanks for your help so far!