Background processing???

[spennyd]

Hi, I have a script in Excel that goes from one worksheet to another, finds data, and then comes back to the original worksheet and populates text boxes with the data found in the second one. So when I click on a valid cell in the first sheet, the second sheet quickly pops up, then I see the program quickly scroll through all the data in column A until it finds a match, and then it goes over to find the data, all before going back to the original sheet. Does anyone know if there is a way to have the whole process run without the user seeing all of the steps flash before them? Is there some kind of background processing code that I can add to my script?

Thanks a ton!

[Br1an_g]

add the following to the start of the section of code:

Application.ScreenUpdating = False

you could also add:

Application.DisplayAlerts = False

[spennyd]

Thanks Brian, that worked like a charm!