Grayovich
03-30-2020, 05:51 AM
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!
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!