Use message box variable

[brookr1988]

Good morning

Not knew to here but for the life of me i cant remember my old details.

I have built a macro which, in essence. Looks for a name, performs a match on a different workbook, identifies the correct row , selects that row, and pastes it back in the original document.
I have having problems with the match failing due to naming differences.

Is there any way i can have a message box to appear and ask for a new name.
So for example, the original variable is "Orange", but in the other workbook its called "Oranges", so in stead of ending the macro, the message box appears, asks for a different name which can be manually entered and then the macro continues.
Or if that entry just does not exist in the other workbook at all, the message box will say, would you like to 0 the results.

Please find below my macro as it stands. The variable i am looking for is P.
Any help would be appreciated, or if you require further information please let me know.
Thanks !

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)