"Runtime error '9': subscript out of range" when running UserForm

Afternoon!

I'm working on a simple project 'database' of sorts for my company.
I've created a UserForm to make the data entry easier, using a macro set I found online.

When adjusting the naming conventions to meet my needs, I continually come up against the "Runtime error '9': Subscript out of range" bug. (The code below shows my edits.)

I have checked, and re-checked the sheet names, and cannot find the error.

The debugger is highlighting the piece of code in red below (I can't post links or pictures yet, so this will have to do )

Private Sub cmdAdd_Click()
'Copy input values to sheet.
Dim lRow As Long
Dim wb As Workbook
Dim ws As Worksheets

Set wb = ActiveWorkbook
Set ws = wb.Sheets("Projects")

All help is much appreciated!

Please Login or Register  to view this content.

You say the debugger highlights the text in red, but the debugger image shows it is highlighting the line below that.

That should indicate there is no worksheet named "Projects" in the ActiveWorkbook and if there is, the sheet name may not be exactly like it shows in the code. There may be a space or caps are different.