VBA If cell is under a certain length, highlight and display message

Any of those help I have an excel sheet with column A having values A, B, C, D, E. They are merged cells. A1 to A3 with value A. B1 to B3 with value B and so on. Column B has certain description for each value in column A like Apple, aeroplane, ant for value A. banana, bat,ball for value B and so on. Column c blank from c1 to c15. if i select cell c1 or c2 or c3, then A has to be displayed on message box. if i select cell c4 or c5 or c6, then B has to be displayed on message box. if i select cell c7 or c8 or c9, then C has to be displayed on message box. if i select cell c10 or c11 or c12, then D has to be displayed on message box. if i select cell c13 or c15 or c16, then E has to be displayed on message box. , If you want to use a formula you could do the following:

=INDIRECT("A"&ROW()-MOD(ROW()-1;3))

MsgBox Range("A" & Selection.Row - (Selection.Row - 1) Mod 3).Value

should help you out I am new to jsp / servlet and related domains. I am trying to display a message on a gridPagingToolbar based on length of myDataStoreDs. , I figured it out.

<j:gridPagingToolbar dataStoreId="myDataStoreDs" gridId="myExampleGrid" exportEnabled="true">
        <jsp:attribute name="startItems">
            myLib.Util.removeNulls([null
                ,   {
                    xtype: 'tbtext',
                    itemId: 'toolbarText',                       
                    text: "<j:jsMessage key='diplay text' bundle='bundle.myResourceBundle' />"

                }                
                ,   <j:button type='edit' labelKey="myLabel" handler="myHandler" hidden="true" itemId="myBtn"/>            
        ])
        </jsp:attribute>
</j:gridPagingToolbar>

var text = pageConfigName.myExampleGrid.down("#toolbarText");    
if(pageConfigName.myDatastoreDs.getTotalCount() == 0) {                                         
            text.hidden = true;
    }

around this issue Use the Cells property to get the value of the cell in column A given the row index:

Cells(cell.Row, 1).Value

will help you You could simplify your code, just check if the cells being changed are in Column M, and then check that the number of cells is less than 3.
If those 2 Ifs are not met, the code does nothing, just goes directly to End Sub.

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("M:M")) Is Nothing Then
    If Target.Cells.Count < 3 Then MsgBox "Hey"
End If

End Sub