Excel VBA search cell value and select action if the value exist or not

[Nanouna]

Hy, I made 2 tabs : "Affaires" and "Actions" .

For "Affaires" it's OK: I have my input info Form and my Search and VisualizeFom

Bu for Actions I have a problem: Actually my form allow me to insert data but it's creating a new line each time.
I want the program to check in the "Actions" Tab if the Affaire number (which is in a COmbobox of my Action Form) already exists.
If yes: insert the data of the input form onte same line
If not: create a new line and insert data

Thanks for your help

Nanouna

 

[VoG]

Cross posted Excel VBA search cell value and select action if the value exist or not

Please read Excelguru Help Site - A message to forum cross posters