Screen Updating - Weird Problem 1

[mattygriff]

Hi all.

I have created a workbook using VBA and the functionality is fine but I sometimes get a strange screen problem when entering data into the workbook.

Basically, when data is entered the screen gets messed up with cells and data from one of the other sheets in the workbook. If I scroll up / down or click to another sheet and then back to where I was, everything is OK but that gets a bit irritating when there's a lot of data to enter.

Anyone had similar issues or got any suggestions how this can be cured? I haven't posted any code because I don't know if this is a code-based issue - if it is then I can certainly do so.

Thanks in advance!

 

[Walter349]

This would not be a result of the code running, but rather a resources issue for your workstation.

It would seem from your description, that the video and virtual memory assignments in RAM may be either insufficently assigned or being corrupted by other running processes.

It is possible that you may have a RAM problem, but I would have expected other issues to have occurred to indicate this, but more likely insufficent resources or rouge processes.

There is also the vauge possiblity that the VM area on your HDD may be corrupted.

'If at first you don't succeed, then your hammer is below specifications'

 

[mattygriff]

Walter,

Thanks for the advice. I don't think my machine is particularly well specced up in terms of graphics / video memory so that could well be the problem.

 

[Walter349]

Matty,

In terms of running VBA, you should not need a high end graphics card. Most standard cards or in-built videos will handle it, this is why I suspect a resources problem.

Do you have any problems with other software at all?

To give more advice, I would need more detail about the specs of your workstation and any running processes.

You could use HIJACK for this and provide that information

'If at first you don't succeed, then your hammer is below specifications'