Rich415
New Member
- Joined
- Nov 1, 2011
- Messages
- 1
Hi
Im trying to get excel to user Input boxes to act as password validation using lookups from a worksheet contained within the workbook
For example, when opening the user will be asked for 2 pieces of information, lets say Name and 5 digit password. This information is held within a sheet in the workbook. so a1-a20 contain names and b1-b20 contain the corresponding password.
What i'd like excel to do is match what is entered in the 2 input boxes to the sheet (i think this is a vlookup and an OFFSET formula)
If they match then the user enters the workbook, if not then they get a msgbox reading invalid details.
What i also have is the sheet autopopulating to a table, this currently uses the UserName details but is it possible to use the name what was inputted into the Name inputbox?
Thanks for any help
Rich
Im trying to get excel to user Input boxes to act as password validation using lookups from a worksheet contained within the workbook
For example, when opening the user will be asked for 2 pieces of information, lets say Name and 5 digit password. This information is held within a sheet in the workbook. so a1-a20 contain names and b1-b20 contain the corresponding password.
What i'd like excel to do is match what is entered in the 2 input boxes to the sheet (i think this is a vlookup and an OFFSET formula)
If they match then the user enters the workbook, if not then they get a msgbox reading invalid details.
What i also have is the sheet autopopulating to a table, this currently uses the UserName details but is it possible to use the name what was inputted into the Name inputbox?
Thanks for any help
Rich
