2010 32bit crashes in 2013 64bit

WilliamWu

New Member
Joined
Jul 29, 2013
Messages
6
Hello All

I've developed an application in Excel 2010 32bit.
It has 20+ spreadsheets containing data and equations, and I've created userforms to enter the data for those spreadsheets. These userforms consist primarily of text boxes. You enter the data in the text box and then click a command button that calls a Sub Routine which transfers that data to the spreadsheets. I use a For/Next loop to transfer the data to the spreadsheets. I also use a For/Next loop to return some of the results from the spreadsheets back onto the userform.

My problem now is that it runs perfectly on Excel 2010 32bit, the userforms activate and unload with no errors. But it crashes when I try activating the userforms in Excel 2013 64bit. Is this normal? I have no idea what I am doing wrong.

I've included an example of the code that I use in the userforms. When the userform activates, the code displays the results in the spreadsheet in 42 textboxes. The results are in a vertical table, hence the loop function. The code to transfer the data to the spreadsheet, follows the same structure.

Code:
Option Explicit

Dim WS as worksheet
Dim ID As Integer
Dim RowStart, ColumnStart As Integer

Private Sub UserForm_Initialize()

Set WS = Thisworkbook.Sheets("Data1")

End Sub

Private Sub UserForm_Activate()

Call LoadResults

End Sub


Private Sub LoadResults()

RowStart= WSCharInput.Range("InputRow").Row
ColStart= WSCharInput.Range("InputRow").Column

If lbl_ProjectName.Caption = "No Project" Then 

    For ID = 0 To 41
    Me.Controls("TextBox" & ID).Value = vbNullString
    Next

Exit Sub
End If

For ID = 0 To 41
Me.Controls("TextBox" & ID).Value = WS.Cells(RowStart + ID, ColStart).Text
Next

End Sub



Thanks
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,302
Messages
5,836,512
Members
430,436
Latest member
fefenouil

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top