If textbox 1 is not empty then fill textbox 2

[dotchieJack]

Hello every body.
I have 15 comboboxes and 2 textboxes
If I choose a value in one of these comboboxes (value = Mdif) then it should fill textbox 1
but if textbox 1 is already filled it should fill textbox 2 and if the 2 textboxes are filled and someone chooses for the 3 time the value Mdif then they should get a messagebox textboxes are full
Something in this direction

Private Sub ComboBox1_Change()
If ComboBox1.Value = "Mdif" Then
TextBox1.Value = Label1.Caption
Else
If TextBox1.Value > 0 Then
If ComboBox1.Value = "Mdif" Then
TextBox2.Value = Label1.Caption
End If
End If
End If
End Sub

Thanks in advance

 

[NARAYANK991]

Hi ,

See if this works.

Private Sub ComboBox1_Change()
            If ComboBox1.Value = "Mdif" Then
               If TextBox1.Value = vbNullString Then
                  TextBox1.Value = Label1.Caption
               ElseIf TextBox2.Value = vbNullString Then
                  TextBox2.Value = Label1.Caption
               Else
                  MsgBox "Both textboxes are populated !", vbOKOnly
               End If
            End If
End Sub

Narayan

 

[dotchieJack]

Hello Narayan,
Perfect
Thank you so much
Jack