Thread: System is really really slow during data entry...VBA problem?

Hi there,

I have a test application up and running. The main problem is......during data entry, the system is responding really really slow. At the lower right hand corner, it is actually telling me which processors are running(4 of them), and % of completion....

The sheet I've been working on is "VGH Clinic Intake"

Perhaps it is the VBA code I have written? In some other worksheets, thare are embedded calculations as well, which involve another workbook. Could this be the reason???

could anybody help troubleshoot?

Much appreciated.

thank you

You're limiting the cells using selection change events. Instead, try using sheet protection or the Scroll Area property.

Hi,

Could you point me in the right direction? I'm not sure how to do so. Did you mean worksheet change event? Yes, everything is in worksheet change event.

When you protect the sheet, will the calculation update as well?

what is the scroll area property?

sorry...I'm new..

Originally Posted by Lifeseeker

When you protect the sheet, will the calculation update as well?

No reason it wouldn't. You would unlock all the cells that you would wish the user to access and then apply the worksheet protection, locking out all other cells by default.

Originally Posted by Lifeseeker

what is the scroll area property?

sorry...I'm new..

From Excel VBA help...

ScrollArea Property
See AlsoApplies ToExampleSpecificsReturns or sets the range where scrolling is allowed, as an A1-style range reference. Cells outside the scroll area cannot be selected. Read/write String.

Remarks
Set this property to the empty string ("") to enable cell selection for the entire sheet.

Example
This example sets the scroll area for worksheet one.

Worksheets(1).ScrollArea = "a1:f10"