Private Sub Worksheet_Change(ByVal Target As Range)Can you post a sample workbook showing the relevant sheets. I'm not clear if C3 and D3 etc. are on the password list sheet or elsewhere and I suspect there may be other code, ptherwise how is FindPSWD run?

The automated code is triggered by an "Event" macro. In this case a change to the value of C3 on a particular sheet uses the built in routine
"Private Sub Worksheet_Change(ByVal Target As Range)"