' At the start
Application.ScreenUpdating = False
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
' At the end
Application.Calculation = xlCalculationAutomatic
Application.EnableEvents = True
Application.ScreenUpdating = True
Try putting this after the Screenupdating True/False lines
VBA Code:' At the start Application.ScreenUpdating = False Application.EnableEvents = False Application.Calculation = xlCalculationManual ' At the end Application.Calculation = xlCalculationAutomatic Application.EnableEvents = True Application.ScreenUpdating = True
That is not quite what I had in mind. I wanted actual examples I could copy (which is which I capitalized DETAILED and SPECIFIC), i.e. enter 123 in cell A23, then 456 in cell J23, etc.As I enter a value on the Proforma sheet in column B, and then hit enter to enter the next value, the blue loading circle populates and then flickers.
As I move down the sheet to the Payables Services or Wire Transfer Services, the flickering gets worse.
Google "Create Userform in Excel VBA". You will find many different tutorials on the topic.I like your idea of the submit or a user entry form where they enter the values and it runs at once.
How would I go about that?