View original (French)

Run a macro on dropdown list selection
NASRAOUI87 -  
Hello

I have a dropdown list ''' in cell C6 ''''' , the list contains 5 choices (screwing, wave, troubleshooting, AQ, and packaging)
I want the macro BDdevis to run automatically every time I change the choice in this list.

3 answers

  1.  M-12
    Hello everyone

    place this macro in the sheet and every time the list in C6 changes, the macro will run (check the spelling of the macro name) 

    Private Sub Worksheet_Change(ByVal Target As Range)
     If Not Application.Intersect(Target, Range("C6")) Is Nothing Then
     Call BDdevis
     End If
    End Sub
    1
    1. NASRAOUI
      Thank you very much, it works as it should now.
      0
    2. michel_m Contributor
      And I smell the pâté?
      1
    3. M-12
      Hello Michel.m

      But no, your message has probably been seen and understood

      After that, if you're waiting for thanks from all the people you're helping out, well for some, you just have to take note of them and ignore them afterwards.
      0