Change cell value selected by combobox1 in value combobox2

    Re: Change cell value selected by combobox1 in value combobox2


    Pike,


    ReTanks for the help.


    But at this moment it does not do exactly what I want.
    The mean was that the value of combobox2 is placed in the cell. At this moment I can change the cell by changing the textbox value, but the selected value of combobox 2 is not placed in the textbox, and so the cell is not changed into the combobox2 value.


    aisietie

    Re: Change cell value selected by combobox1 in value combobox2


    OK,


    There are 2 comboboxes and 1 Textbox.
    With Combobox1 I select a Row, the value of the correspondant cell in column C is shown in Textbox1. Here is everything a Big OK!
    With Combobox2 I select a value from a list, that value should be placed in the textbox1, and so in the corresponding cell of textbox1.


    Thanks for trying understanding,


    aisietie

    Re: Change cell value selected by combobox1 in value combobox2


    Avari,


    Why don't you start a new thread?
    I feel a little overtaken.


    Grtz aisietie

    Re: Change cell value selected by combobox1 in value combobox2


    This may be a little closer

    Code
    Private Sub CommandButton1_Click()
    If Me.ComboBox2.ListIndex <> 0 Then
        Sheets("FSM").Cells(Me.ComboBox1.ListIndex + 1, 3) = Me.ComboBox2.Value
        Me.TextBox1.Value = Me.ComboBox2.Value
    End If
    Unload UserForm1
End Sub

    Re: Change cell value selected by combobox1 in value combobox2


    Goodmorning Pike,


    Thx, that goes well.


    This part of my problem is completely solved.


    For the next problem I start (soon) a new thread.


    Grtz and many thanks,


    aisietie


    Thank you


    aisietie

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login