View original (French)

Run a macro when a cell contains a specific value

Solved
roouumm Posted messages 7 Status Member -  
roouumm Posted messages 7 Status Member -
Hello,

I need your help!

Is it possible to trigger a macro when a cell contains a specific value?

Let me explain my case:
In one sheet I would like to run a macro (Add) when cell L3 contains the value "Valider" or run a macro (erase) when this same cell contains "annuler"

Thanks in advance for your help

Configuration: Configuration: Configuration: Windows / Chrome 55.0.2883.87

2 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello

    how is "formé valider - effacer dans la cellule L3: résultat de formules saisies, liste de validation....." formed?

    --
    Michel
    1
    1. roouumm Posted messages 7 Status Member
       
      Cancel and validate are entered/filled using a handheld scanner (barcode reader)
      It's in standard format
      0
      1. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320 > roouumm Posted messages 7 Status Member
         
        Sorry, but is it your dropper that writes directly to validate or erase in the cell?
        0
    2. roouumm Posted messages 7 Status Member
       
      Yes, exactly
      0
      1. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320 > roouumm Posted messages 7 Status Member
         
        thank you, I'll check in 2 or 3 hours
        0
      2. roouumm Posted messages 7 Status Member > michel_m Posted messages 18903 Registration date   Status Contributor Last intervention  
         
        Thank you :)
        0