Multiple values for Q2...

[jrvoice]

Hi,

I'm looking to use multiple values in Q2 at the start of my day... I want:

-3 to re-load the quick pick list
-7 to clear the bet results sheet
-5 to load the first race - shouldn't be necessary but just in case

I want to do all these from a macro... I've tried placing the value, sleeping (numerous values!) and then firing the next but that doesn't work.

I don't think there is a way to specify a queue of Q2 commands so I'm a bit foxed as to how to do it. If I have different buttons which call individual macros to enter the values it works fine; its how I handle more than one I have the problem with!

...as an aside, I've noticed that after a -7 clears the results sheet it can sometimes reappear.. the same happens if you manually delete A2:F1024. Is this a caching feature of Excel or BA and can it be fixed? I have some 'emergency stop' conditions watching the results sheet which fire unnecessarily if yesterdays' results reappear.

Many thanks!!

Jon

[GaryRussell]

Don't use sleep, it will not work. BA processes the Q2 trigger on each refresh so you need to let it do its work between refreshes.

See http://gruss-software.co.uk/forum/viewtopic.php?t=3558 for an example that uses -3 to load the quick pick list then uses -5 to select the first market. It all happens in the Worksheet_Change event. It inserts -3 then sets a flag so that on the next refresh it knows to insert -5.

It doesn't seem possible that the results could reappear. Are you sure it's not the case that -7 wasn't processed at all?

the same happens if you manually delete A2:F1024.

This is not the same as using -7. -7 instructs BA to remove the list from memory. It writes it from memory on each refresh so blanking the worksheet will have no effect. Basically if after using -7 you can see that the results have cleared there should be no way for them to reappear because BA no longer has them in memory.