Hello,
Is there a way to select a userform listbox item based on the string in a cell? The listbox will already contain the item. I tried the following:
'update userform
Me.xMachineTypeListBox.Selected = CStr(wsFPY.Cells.Range("C" & contractLocation.Row).Value)
I found quite a few posts regarding populating a listbox but didn't find any regarding selecting an item that is already in the listbox.
Any suggestions greatly appreciated.
Is there a way to select a userform listbox item based on the string in a cell? The listbox will already contain the item. I tried the following:
'update userform
Me.xMachineTypeListBox.Selected = CStr(wsFPY.Cells.Range("C" & contractLocation.Row).Value)
I found quite a few posts regarding populating a listbox but didn't find any regarding selecting an item that is already in the listbox.
Any suggestions greatly appreciated.