Populate Cells From Multiple ListBox Choices

    HI,


    I am having a problem with some code I am trying to work with. My problem is that I need to source information which is selected on a userform in 3 list boxes and copy this information into the excel sheet behind on the same row.


    Can anyone help?


    Thanks


    Richard

    Re: Copy Information Selected In Listbox


    Quote from wallar

    ....... 3 list boxes and copy this information into the excel sheet behind on the same row.

    What do you mean same row on sheet behind? Userforms don't have rows so how can it possible be the same row?

    Re: Copy Information Selected In Listbox


    Heres a stab in the dark:


    Code
    Private Sub CommandButton1_Click()
    Range("A1").Value = Me.ListBox1.Value
    Range("B1").Value = Me.ListBox2.Value
    Range("C1").Value = Me.ListBox3.Value
End Sub

Participate now!

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

Register Yourself Login