ptibat | Voila j'ai essayé de faire qq chose en VB mais ca marche pas, y'a un trucs qui va pas .... Please Help ...
Code :
- Private Sub ComboBox1_Change()
- ComboBox1.AddItem WorksheetFunction.VLookup(Range("B27" ), Range("B3:F12" ), 2, False)
- ComboBox1.AddItem WorksheetFunction.VLookup(Range("B27" ), Range("B3:F12" ), 3, False)
- ComboBox1.AddItem WorksheetFunction.VLookup(Range("B27" ), Range("B3:F12" ), 4, False)
- ComboBox1.AddItem WorksheetFunction.VLookup(Range("B27" ), Range("B3:F12" ), 5, False)
- End Sub
- Private Sub ComboBox1_Initialize()
- ComboBox1.Clear
- End Sub
|
Merci |