Detect Enter Key and search value in a range

[jamiguel77]

Hi friends.

How to do:

the user start capture in cell A1="APPLE" go to A2 and capture "ORANGE" and then the user capture in A3="APPLE" here how to check every capture if exist say a message: "Error, captured on A1"


or only can do the task, with a button and with vba code?


thanks

 

[jamiguel77]

Sorry, I'm struggling to understand that - language translation problem? Perhaps you could try again & try to be more more careful with the English if you can.

ok i try

First Thanks for explanation...
Second: i have this macro:

Sub Promedios(value as String)
Dim suma As Double
Dim promedio As Double
Dim n As Double
Dim celda As Range

    suma = 0 'acumula los valores
    n = 0    'cuenta los valores
    
    For Each celda In Selection
        n = n + 1
        suma = suma + celda.Value
    Next celda
    
    promedio = suma / n
    MsgBox "Valores leÃ*dos = " & n & vbCrLf & _
           "Suma = " & suma & vbCrLf & _
           "Promedio = " & promedio
End Sub

how to call from Data verification?

Thanks

 

[Peter_SSs]

how to call from Data verification?

Data Validation itself cannot call a macro. You could try a Worksheet_Change event that monitors the DV cell(s) and if those cells are changed call the macro.