I have to admit, I am a brute force vba user...not a whole lot of knowledge, but a whole lot of luck! So, if you can provide an answer, please try and abvoid all the mumbo-jumbo Excel vba help stuff like...object...syntax,,,etc. Please stick with real code :-) Thanks!

I have a workbook that I am trying to allow users to set their own passwords. Within the workbook, there is a well hidden and well protected table of user names and associated passwords. For simplicity sake, we will say user names are in column A and passwords stored in Column B.

The code I have so far is this. Where it says the password already exists, try again, I would like the program to loop back to the input box to enter a new password.

ActiveCell.Offset(1, 0).Select
ActiveCell.Value = InputBox("Please enter your new password now")
Dim Line
Line = Application.Match([B3], Sheets("MRB-SDR Password").[B:B], 0)
If IsNumeric(Line) Then
MsgBox ("Password already used, please try again")
Else

ActiveCell.Offset(1, 0).Select

End If

ActiveCell.Value = InputBox("Please re-enter your new password now")