VBA message box code - help needed

[PGD15]

Hi,

i am trying to write some code in VBA that says when a button is click check if cell L49 is populated with the value yes then Cells L52,L55,L58 will each needs to be populated, if they are empty I need a message box to appear, if the Cell L49 doesn't say yes the script can end at that stage.

so something like:
on_click()
if range("L49").value = "yes" then
range("L52").value = "" is true
msgbox "Please enter a value"

then repeat this for them all, i know this doesn't work but just to help make clear what i'm asking

 

[Because Reasons]

Depending on where the code is being placed in the VBAproject, you may need to put in the worksheet name. Assuming you don't, try this.

[COLOR=#333333]on_click()[/COLOR]
[COLOR=#333333]if range("L49").value = "yes" and  range("L52").value = "" or range("L55").value = "" or range("L58").value = "" then[/COLOR]
[COLOR=#333333]
msgbox "Please enter a value" 

[/COLOR]end if

alternately, if you need to put the worksheet names in it would look like this:

[COLOR=#333333]on_click()[/COLOR]
[COLOR=#333333]if [I]worksheets[name].[/I]range("L49").value = "yes" and  [/COLOR][I]worksheets[name].[/I][COLOR=#333333]range("L52").value = "" or [/COLOR][I]worksheets[name].[/I][COLOR=#333333]range("L55").value = "" or [/COLOR][I]worksheets[name].[/I][COLOR=#333333]range("L58").value = "" then[/COLOR]
[COLOR=#333333]
msgbox "Please enter a value" 

[/COLOR]end if