Showing/Displaying Message to User

Hi im currently doin a A level in ICT, Part of this is numerical numbering and modeling, im having trouble with part of this work, i have a range of 3 cells (L9, L10 and L11) which i have named as a group (Option_Block) each of these cells has the formula =IF(K9<15,"A","FULL") what i would like todo is show a message in a new cell for example C20 and if one of the 3 cells (L9, L10 and L11) show FULL then the message - "Group Full please select another Group" will appear.

I dont know if anyone can help me, if not nevermind

Thnks

Hi

Just as a note it always a good habit of posting a sample of your works

You could try this code
Sub full_message()
Range("L9").Select
L9 = ActiveCell.Value
Range("L10").Select
L10 = ActiveCell.Value
Range("L11").Select
L11 = ActiveCell.Value
If L9 = "FULL" Or L10 = "FULL" Or L11 = "FULL" Then
'MsgBox "Group Full please select another Group"
Range("C20").Select
ActiveCell.Value = "Group Full please select another Group"
End If
End Sub