Developing VBA apps and Excel versions

[jbwilks6]

I am developing a vba/excel app for a client and trying to determine which version of excel I should develop it in. The client uses the following Office 365 version:
Microsoft® Excel® for Microsoft 365 MSO (Version 2210 Build 16.0.15726.20188) 64-bit

But I know online office 365 doesn't even allow for vba development.
So I started to develop in excel 2019 but kept getting errors in simple code:
run-time error '2147417848 (800101108)
Method 'Value' of object 'Range' failed

So I am planning to use a copy of Excel 2010 that I have. Will this work? What is the best practice to deploy vba apps. Will I just have to have the client install a local copy of Excel 2010?

 

[MARK858]

So I started to develop in excel 2019 but kept getting errors in simple code:
run-time error '2147417848 (800101108)
Method 'Value' of object 'Range' failed

What code are you using when you get that error as it isn't normally version dependent?

 

[jbwilks6]

It's when I try to update a worksheet range with values from textboxes on a user form. It fails on .Cells(newRow, 1).Value = txtMemberID.Value. Couldn't get around it. Googled, researched everywhere and can't find solution. So in my 2010 version it does not produce the error.


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
.Cells(newRow, 4).Value = txtStreet1.Value
.Cells(newRow, 5).Value = txtStreet2.Value
.Cells(newRow, 6).Value = txtStreet3.Value
.Cells(newRow, 7).Value = txtStreet4.Value
.Cells(newRow, 8).Value = txtCity.Value
.Cells(newRow, 9).Value = txtState.Value
.Cells(newRow, 10).Value = txtCountry.Value
.Cells(newRow, 11).Value = txtZipcode.Value
.Cells(newRow, 12).Value = txtEmail.Value
.Cells(newRow, 13).Value = txtStatementName.Value
.Cells(newRow, 14).Value = txtPhone.Value
End With
End Sub

 

[NdNoviceHlp]

If your userform name is Userform1...

With Sheets("shMembers")
.Cells(newRow, 1).Value = Userform1.txtMemberID.Value

HTH. Dave

 

[jbwilks6]

If your userform name is Userform1...

With Sheets("shMembers")
.Cells(newRow, 1).Value = Userform1.txtMemberID.Value

HTH. Dave

Thanks for trying but still get the error. actually what your code does is call the userform initialize event again (which I don't want) and then execeutes the line and still gives the error. I can't find a resolution by anyone that has experienced this error. I am really wondering if using excel 2010 which doesn't give the error is really a good idea to develop applications to deploy on other's machines though

 

[NdNoviceHlp]

Those were just 2 lines of code that I thought could be improved (ie. there are multiple lines without the userform1). Is this userform code? There is no way that it should cause the userform to initialize again? I would check to make sure that your sheet name, userform name and control(s) names are all correct. Dave

 

[Rick Rothstein]

Comment out that first line that you posted about and run your code... do you still get that error on the next line of code?

 

[jbwilks6]

Comment out that first line that you posted about and run your code... do you still get that error on the next line of code?

No. But I completely rebuild the app from scratch and it works with no error with the same code. I guess the workbook was corrupted or something