IF cell A = Y and cell B = "" THEN = messagebox

[jammy78]

Hi,

This is a really simple one but I can't get it to work:

I have a dropdown list with Yes or No in cell M14.

I need the VBA code for:

When M14 = Yes and M16 = "" (empty)
for a message box to appear with "Please state the Filename"

Many thanks

[MaczaQ]

try this way ... type below code in your sheet's code

Please Login or Register  to view this content.

[jammy78]

Sorry, I should have probably said - I want to add the code to an existing command.

This is some of the code in the command:

Please Login or Register  to view this content.

So I need to add it to this!

[john55]

see the code provided by maczaq and change it for yr needs
as an option

Please Login or Register  to view this content.

[MaczaQ]

nothing more to say that john55 wrote

maybe shorter code ?

Please Login or Register  to view this content.

[jammy78]

nothing more to say that john55 wrote

maybe shorter code ?

Please Login or Register  to view this content.

What a fool..... I forgot to put the " " round the yes, when I tried! It was a long day.......... ?

Many thanks for the help!