Create a pop-up form for entering current 'block' of cells

PMHunt1955 Hi Philip, to start with your last question: if you click the Reply button rather than the "Quick reply" button and select the Rich Text tab at the top of the small reply window, you should see a button </>. Click that to insert code.

To your other questions.

Best to put both the OnKey routine and the routine that opens the form in a normal module:

Sub ShowBaptismEntryForm()
    Enter_Baptism.Show
End Sub

Sub SetHotKey()
    Application.OnKey "+^b", "ShowBaptismEntryForm"
End Sub

Sub ResetHotKey()
    Application.OnKey "+^b"
End Sub

And in ThisWorkbook:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
   ResetHotKey
End Sub

Private Sub Workbook_Open()
    SetHotKey
End Sub