Hi, all,

I have a project created with VB from which I will load data from DB to a spreadsheet, because it takes time, I also create a small frame on which there is a progress bar.

My problems are:

1: while load data to spreadsheet, I use some codes like the following:

Worksheets("General Analysis").Activate
Range("B10").Select

ActiveCell.Offset(I, 0).Value = SF_ID
ActiveCell.Offset(I, 1).Value = SF_Toe
ActiveCell.Offset(I, 2).Value = fRGv

everything is fine, but if I scroll down or click the page, I will get runtime error:
Runtime error 50290, application-defined or object defined error"
and this error may happen in different line each time.

2: If I don't make the spreadsheet file showing on the window, instead, show progress bar. everything is also fine, but If I click on this form, a system alert will appear with two buttons: Switch and Retry (not all computer has this issue.).

How can I avoid these issue. I google this runtime error, a lots of posts but no answer.

Thanks!