Excel running slow due to macros

Hello,

I'm new to VBA and I need some help with speed being slow when inputing data into my file (sorry for my data being in French). When I input data in the Fields entitled "École", "Année scolaire", i can't do anything for about 4 seconds. When I input data into the field "Nombre d'élèves", and I click on the big yellow button to get to another sheet (see 2nd image) then the number of lines showing should match the number inputed on the first sheet by using a code (see below - code) (I have two other similar sheet using the same code that is password locked which you can access by clicking on the left green button on the 1st image, but those sheets are running a little faster) and there are also some formulas in the sheet itself (see below - formulas)

Image 1
Screen Shot 2022-01-31 at 11.21.57 AM.png

Image 2
Screen Shot 2022-01-31 at 11.25.52 AM.png

Code

Please Login or Register  to view this content.

Formula
=IFERROR(IF(Accueil!E13="","",1),"")
=IFERROR(IF(A11+1>Accueil!E$13,"",Ecole!A11+1),"")

where "Ecole" is the active sheet (image 2) and "Accueil!E$13" is the cell I inputed the number 2 in image 1

I then manually input data in the other columns in image 2 and here is where it gets really slow, about 15 seconds before I can click in another cell.

I must say that the data inputed into image 2 is beeing copied to 3 other sheets.

Any help would be appreciated

Hi Richard,

Thanks for your reply. Like I said i'm fairly new to this. I tried to upload a part of my file but it is too big. Every code is doing what it is suppose to do. Except it runs really slow. I can see the word "Calculate" in the botton left of my screen every time I input data into a cell. My question is, how do I make it faster. I can't ask people to share me their data if they have to wait 15 seconds every time they input data into one cell, they have 18 cells per row to input data. I could send you my file by email if that would help. I really appreciate you taking the time to help me with this.

Janie

Without an example file, it's hard to guess where the problem lies. We can only guess that the Calculate event arouses too often.
For now, try changing the procedure like this:

Please Login or Register  to view this content.

Artik

I don't really need to run a loop. I would prefer applying changes when i press a button. But what would the code look like ? And would I be placing the code in a module instead of directly on the sheet?

Sorry If I didn't follow the rules......I was unaware. So now that I know I will abide by them. I asked the same questions in two other forums as I was in a crunch to present my work to my employer. I did find a solution in another forum. I'm trying to copy the link to this thread but it is not letting me.