Select Value From ListBox with DblClick

[Peinecone]

I have have a multicolumn listbox that is populated from data on my sheets. What I would like is to dbl click on a row, and get the value from column 1 in the row that is dbl clicked to show on another form. This is what I have so far for the code

Private Sub lstRecipes_DblClick(ByVal Cancel As MSForms.ReturnBoolean)

    Me.Hide
    frmEditRecipe.Show
    frmEditRecipe.cboRecipeName.Value = Me.lstRecipes.List().Value 'This needs to be the value in column1 of the row that is dbl clicked.
    Unload Me
    
End Sub

The row that populates column 1 is the same data that populates the combobox in frmEditRecipe.

 

[John_w]

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    Label1.Caption = ListBox1.List(ListBox1.ListIndex, 0)
End Sub