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:
MsgBox Range("A" & Selection.Row - (Selection.Row - 1) Mod 3).Value
Display message on gridPagingToolbar based on restDataStore length
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"
Cell Selected should display message which is on a cell on another sheet