Automatic sub run using external data tags

[The Mat Hatter]

Hi,

I am utilizing tags that are imported using a 3rd party program, and they gradually change over time. What I want to do is set up my program so that I can leave this workbook up continuously, and have the sub run every time the tag is updated. There are a variety of locations where these tags are located on the sheet, so I would prefer to have it run when any tag is updated, not just specific ones. The tags are entered in the form of a formula, so I though worksheet_calculate was the way to go, but I used randbetween() to simulate changes, and each time I hit F9, nothing happened as far as the macro I wanted to run.

The macro will run each time I run it manually, so I know the process if fine, I just don't know how to call it properly. What I have used is below:

Private Sub worksheet_calculate()


'make_color_bars macro

End Sub

AND

Private Sub worksheet_change()

'make_color_bars macro

end sub

I have also set it up to where the macro would just run every x amount of seconds. This works, but it is not preferable.

Thanks in advance!

 

[StephenCrump]

Works for me, that is if have:

make_color_bars macro

i.e. rather than the commented out:

'make_color_bars macro