Forum

Create a Data Valid...
 
Notifications
Clear all

Create a Data Validation with Multi Selection

4 Posts
2 Users
0 Reactions
52 Views
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

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

 
Posted : 08/04/2020 7:54 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Maruizio,

See attached workbook for working code.  You'll need to modify it to use your own data validation list.

Regards

Phil

 
Posted : 09/04/2020 4:07 am
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

Hi Philip
How fantastic you are
If I wasn't there; They should invent you
It was just what I was trying to do; But without being able to do anything.
Thanks Infinite
Sincere greetings from A.Maurizio

 
Posted : 09/04/2020 1:45 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

🙂 You're welcome.

 
Posted : 09/04/2020 4:54 pm
Share: