• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data Validation: Restrict user to input specific texts available in master list

S

syp1677

Member
Dear Gurus,
I want to do data validation, where user can input only those specific texts separated by commas without space from the master list. I have attached an example file for reference. Comments are entered for guidance in the file.

Thanks in advance.
Best Regards,
S
 

Attachments

  • Test31082023.xlsx
    13.9 KB · Views: 3

syp1677​

One other basic way would be possible to solve this...
... users should follow those rules be themselves.
There would be other possibilities, but
I would use something like that.
Or
something like this.
Instructions:
#1 Select Input Data cell >> green
#2 Select cell from Master List >> adds it, if none before ... or deletes it
#3 repeat step 2 as many times as needs
#4 if select Master List header then it will delete whole selected Input Data cell
Ps, Note tested with all (im)possible variations of user selection.
 

Attachments

  • Test31082023.xlsb
    19.5 KB · Views: 2
Last edited:
Hi vletm,
Thanks... the last option works extremely well. I did not get understanding of your code. I want to repeat same for other columns as well. Can you please elaborate. What if I have data validation list in another sheet?

Best Regards,
S
 

syp1677​

It was a sample and it works as it works.
I waited Your response few days after that and I did other version, which works more suitable for me.
You should able to explain and give clear samples - what do You really would like to get?
 
Hi vletm,
Thanks for the response. Sorry for delayed response. I was actually trying to experiment one of my own on the sheet. Before putting up the question.
Please refer Attached file. I want to design macro so as to restrict users to for filling certain data which I am doing by Data validation. There is one column "F", where actually need addition of multiple data separated by comma",". Also after entering data I need to put program by which it will save only sheet 1 with only cells A2:XFD to new workbook xyz.xlsx.

Best Regards,
S
 

Attachments

  • test.xlsx
    10.1 KB · Views: 1
You must log in or register to reply here.
Back
Top