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 codeThe row that populates column 1 is the same data that populates the combobox in frmEditRecipe.
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