XL 2019 if then else combobox

evladi16

XLDnaute Nouveau
La Condicion IF, Then, ElseIF no Me funcionan aki el ejemplo
EjemploComboBox-IF,Then,ElseIF.jpg
 

Pièces jointes

  • EjemploIF_ElseIF.xlsm
    14.7 KB · Affichages: 7

_Thierry

XLDnaute Barbatruc
Repose en paix
Hello @evladi, le Forum

Sorry it is a french Excel knowledge forum, not sure what you ask, but try this :

VB:
Private Sub ComboBox2_Change()
If ComboBox2.ListIndex = -1 Then
    ComboBox1 = "1 Hijo"
Else
    ComboBox1 = "2 Hijo"
End If
End Sub

(No more : Private Sub ComboBox2_Click)

Best
Thierry
 

Discussions similaires

Réponses
21
Affichages
1 K