Hi Guys!

i have developed a Dashboard in which i have create ListBox (ActiveX Control) now i want to give password on a specific value selected in ListBox.
for example in ListBox there are: Pen, Book, Keyboard and Laptop. Now if anyone select Laptop than excel will ask him for password to show the data otherwise it will auto select the first/other value of the list. Hope you understand

I have found this formula but this if for DropDown List i actully need same thing for my ListBox

Please Login or Register  to view this content.