View original (French)

Run a macro on dropdown list selection

NASRAOUI87 Posted messages 6 Status Member -  
M-12 Posted messages 1349 Status Member -
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 Posted messages 1349 Status Member 285
     
    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 Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
       
      And I smell the pâté?
      1
    3. M-12 Posted messages 1349 Status Member 285
       
      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