Create a Data Validation with Multi Selection|VBA & Macros|Excel Forum|My Online Training Hub

Hi everyone, my name is Maurizio
and my new problem is this.
using the Vba
it would be possible to take advantage of the validation Data in Multiple Form.
example: I create a drop-down menu with data validation on sheet 1 '
While the main data are entered on sheet 2.
Now on sheet 1 I would like to be able to get the drop-down menu located in cell (C2) where all the items entered by me on sheet 2 are displayed
But at this point, rather than being able to select only one item, I can select Two or more items and placed on the same cell as sheet 1
thanks