Hi all,
I have a user-form which inputs data into a "database" worksheet. I have an "edit" command button which then repopulates the user-form in "EDIT" mode.
Upon clicking the "Edit" button on the "Home" work sheet, I would like to be able to pre-select the list box options based on the entries in the reference cell in the Database!ColumnI "Location of Employment" which is comma and chr(10) separated on to a new line. I know that the sub needs to loop but i am struggling to understand in general where i am going wrong.
Please see attached file.
Any help would be much appreciated.
Thanks in advance.
Bookmarks