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

Answer 1 / 3
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
NASRAOUI
 
Thank you very much, it works as it should now.
0
michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
 
And I smell the pâté?
1
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