run-time error '2147417848 (800101108)Method 'Value' of object 'Range' failed

[jbwilks6]

I am getting this error while trying to update cells in a worksheet from my textbox values on a form.

Private Sub WriteDataToSheet()
    Dim newRow As Long
    With shMembers
        newRow = .Cells(.Rows.Count, 1).End(xlUp).row + 1
        .Cells(newRow, 1).Value = txtMemberId.Value
        .Cells(newRow, 2).Value = txtLastName.Value
        .Cells(newRow, 3).Value = txtFirstName.Value
    End With
End Sub

It fails on the line: .Cells(newRow, 1).Value = txtMemberId.Value

I have a copy of MSOffice 2019 professional but I keep getting the product is not genuine warning which I am not sure why because it should be genuine. I tried repairing and re-installing the office 2019 app but still getting the error.
So I am considering just updating to Office 365 to see if it fixes it, but I am wondering why this is necessary when I already purchased 2019 version.

Also, another related question is, If I am developing VBA/Excel applications, that could potentially be installed on a variety of client machines with different versions of windows or excel, what version of excel/office should I develop my apps on. What is the best practice for this situation?

 

[Micron]

Where is this code? If on a sheet, you're missing the userform reference. If on the userform, I'd preface control name with Me as a habit.
Office 365 is subscription based, which will incur annual fee. I'd google the problem to see if there's something you can do with what you've got.
Usual practice is to develop with/for the oldest version you expect to encounter or are willing to support.