Matteo has attended:
Excel Intermediate course
Excel Advanced course
Data Validation
I built a data drop down list months ago, which I could type anything in the cell without being stopped from Excel for not typing correctly a data from the list. Also while I type I get a suggestion from the list on what I am writing (as the list is very long and that was helpful).
It is very useful but I don't remember how I did it. I only recall I used Visual Basic.
Hope you can help me. Thank you
RE: Data Validation
Hi Matteo,
Thank you for the forum question.
I found three Youtube video. They are all using pretty much the same Technic with a little twist.
I hope this will help you.
https://www.youtube.com/watch?v=Z-h2UER3b_0
https://www.youtube.com/watch?time_continue=1063& ;v=Gm5m-y49rI0
https://www.youtube.com/watch?v=srTteYoqcJs
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector