Passwords for numeric values in drop down lists

Hi all,

I have a drop down (data validation) list of 70 numeric values (each relating to a 4 digit product code).
I want to set an individual password for each product code.

I have searched the forums for a solution to my problem and have found the following thread:

http://www.excelforum.com/excel-gene...down-list.html

I tried editing the top part of the code that begins with Const changing the name to a 4 digit code and i get an error saying "compile error, expected identifier". I don´t understand why Const is not working with a numeric value.

Furthermore, if it worked I assume that I would need to repeat that line of code 70 times.
If possible I would like to save the passwords on a hidden sheet, with the password matched to each 4 digit code.

I attach an excel file with an example

Thank you very much in advance

Please Login or Register  to view this content.

Originally Posted by Svilen

Thank you, Alphafrog!

Perhaps I should have provided more context. The objective is that specific product info can only be visualised if you have the password correct. If you enter a wrong password the input cell should remain blank.

That doesn't explain much. Your example file only has an input box and a sheet with product numbers and passwords. What do you want to visualize? there was no dropdown list or product info.