In the popping up Kutools for Excel dialog box, please enter the interval time you will repeat the macro based on, and then click the OK button. Note: In the code, please replace this line ‘Insert your code here with the code you will run every X minutes.ģ. SaveSetting 'Kutools', 'Macro', 'min', xMinĪpplication.OnTime Now() + TimeValue('0:' + xMin + ':0'), 'ReRunMacro' XMin = Application.InputBox(prompt:='Please input the interval time you need to repeat the Macro', Title:='Kutools for Excel', Type:=2) SaveSetting 'Kutools', 'Macro', 'min', 'False' XMin = GetSetting(AppName:='Kutools', Section:='Macro', Key:='min', Default:='') VBA code: Repeat or loop a Macro every X minutes in Excel Sub ReRunMacro() Then copy and paste the below VBA code into the Code window. In the Microsoft Visual Basic for Applications window, please click Insert > Module. Press Alt + F11 keys at the same time to open the Microsoft Visual Basic for Applications window.Ģ.

The following VBA code can help you to repeat a Macro every X minutes in Excel. Repeat or loop a Macro every X minutes in Excel How to achieve it? Method in this article can help you.

As the data will be changed frequently, you need this Macro to automatically run every 5 minutes without manually triggering it in order to synchronize these two ranges of data. For example, you want to create a Macro to automatically copy a range of data to a new place. While working with Microsoft Excel, you may need to create Macros to achieve some operations. How to repeat or loop a Macro every X minutes in Excel?

Visual basic for excel for loop