Syntax error on msgbox

[Excel_vba]

I am getting syntax errors on the msgbox lines. I think this has something to do with the prompt text continuing to a second line.

Should the end of the first line have a space before or after the underscore or both or does it not matter?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Izandol]

You must concatenate:

Please Login or Register  to view this content.

[Leith Ross]

Hello Excel_vba,

Here is an easier way to validate the entries...

Please Login or Register  to view this content.

[Excel_vba]

Hello Excel_vba,

Here is an easier way to validate the entries...

Please Login or Register  to view this content.

Awesome solution. This saves me the trouble of writing two IFs. I have this macro in the module called "ThisWorkbook" so that the macro runs when the Excel workbook is opened. To test this out, I typed AJJ125 which violates the condition so a message box should have been triggered, but it wasn't triggered.

How can I get this to trigger when I enter the wrong criteria?

[Leith Ross]

Hello Excel_vba,

Copy the macro below.
Select Sheet1 and right click the tab.
Click "View Code..."
Paste using Ctrl V.

Now, whenever data is input into cell G10, it will be automatically validated.

Please Login or Register  to view this content.

[Excel_vba]

Hello Excel_vba,

Copy the macro below.
Select Sheet1 and right click the tab.
Click "View Code..."
Paste using Ctrl V.

Now, whenever data is input into cell G10, it will be automatically validated.

Please Login or Register  to view this content.

Nice. It worked. Thank you very much. But why did you change your code? Wouldn't the original code work inside of the Worksheet_Change event?