Automatcially execute VBA Macro

Hi,

Hoping someone can help.

I don't know much about VBA - in particular within Excel. However, I have created the following "sub"...

Please Login or Register  to view this content.

The macro works but only when I manually run this within the workbook. Can anyone help me to make sure this runs continiously? For example, when cell C1 in sheet 21 changes, for the VBA script to run - I don't want to have to do this automatically.


Sorry if this question has already been asked. A step by step guide will be useful.

Many thanks,

Nick

Open the VB Editor. Click on Sheet1 in the left window. In the right window after clicking, paste in JasperD's code.

nickm84,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.