Multi selection list

[Grayovich]

Hello,
Im using Excel 2013 and am undertaking a project in which I need to create a spreadsheet so that data from paper logs can be recorded. For one of the data fields I need to insert a multi selection list down an entire column (F5 to F200). So that when each cell in that column is selected the list appears.

I’ve created a normal list down the column but I need a VBA formula to allow multiple selections and to allow for selection to be deleted if it was selected in error, e.g. A, B, C were selected, but B was selected in error.

Would anyone kindly be able to assist me with this please?

Apologies for the terrible explanation, needless to say I don’t have a clue what I’m doing!

[SamT]

If you use the "Go Advanced" button, below the post editor, you will see a method to attach and upload an example.