MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Aiden Murphy on January 16, 2002 7:48 AM


i am designing a navagational system for my college IT project

on my first navagational screen i have a password screen, and where i enter my password everyone can see what the letters are, what i would like to know whether i can change those letters to stars so the password is kept secret, also aswell on this screen i would like to know how to put data vialidation on the boxes so that when incorrect data is entered it will come up wiv an error box

Posted by Jacob on January 16, 2002 8:17 AM

If column A contains your "partial" list beginning
at cell A2 and your "master" list is in cells
C2:C10, enter =MATCH(A2,$C$2:$C$10,0) into B2 and
copy down the length of your partial list. Partial
list entries with a corresponding #N/A in column
B are missing from your Master.

Posted by Juan Pablo G. on January 16, 2002 8:26 AM

One easy option that comes to mind. Change the font of the cell you're inputing the password in to one that doesn't have "readable" characters.

Juan Pablo G.