Pre-selecting Listbox value from cell value in Userform

[peterchclarke]

Good Morning All!

I am loading a userform that gets populated with a number of fields from a table depending on the currently selected row.

I would like to use a listbox in the userform to give the user options to change a cell in that row. Effectively using a flat database and a basic front end to edit the data.

I am struggling to get the listbox to be pre-selected with a value.

I am populating the listbox with a dynamic named range to enable more options to be added in the future.

Please Login or Register  to view this content.

the above code successfully populates the listbox, the below code doesn't successfully autoselect the value in column 2 of the table!

Please Login or Register  to view this content.

Please see attached, and please help!

[AlphaFrog]

Please Login or Register  to view this content.

[peterchclarke]

AlphaFrog,

Can't thank you enough. I'm not looking for a lesson, but can you see where I was coming from and can you tell me why it wasn't working??????

Best, Pete

[AlphaFrog]

You're welcome.

Please Login or Register  to view this content.