TPD-ON

[PennyFiddler]

Hi,

I have searched for a method to turn TPD on automatically in VBA and came across a couple of instances of Gary being quoted as saying you can do it by putting TPD-ON (no ") into Q2.

Well VBA seems to dislike the hyphen '-', and wont seem to allow it other than in quotes "TPD-ON" which doesnt work.

Is it correct that this function is working?

Ta

[GaryRussell]

Yes it should be working. I've not seen an issue with VBA complaining about the hyphen. Can you provide example code that causes the error?

[PennyFiddler]

Ermmm

Well yes I think it does work afterall as long as I put it in quotes.

But my rudimentary VBA skills have resulted in an infuriating logical birdsnest of calling macros that torture me, I can either have it change market or activate the TDP, not both.

When the market closed, it copies the data into another sheet through a macro that it runs with
Application.Run "CP_Click"
In that macro it ordinarily set the Q2 (i use named ranges but for this we shall call it Q2) with "-1"
Which in turn forced BA into the next market
Which then activates sheetA code to see theres been a change and calls NewEvent.OpenMarket macro that formats the sheet and sets refresh to 0.2

This all worked.Until.

I tried adding another macro Public Sub NextMarket() that I moved the "-1" to and changed the command in "CP_Click" to activate "TPD-ON" instead, then call NextMarket

And guess what?

I know its obviously not the right way, but it worked upto now
All I want ideally is to add a toggle button to my spreadsheet that I can click- On that will then turn all subsequent market's TPD on so I can leave it alone to run the rest of the day.
How might I do that....without continually swearing at chatGPT?

Sorry, I tried.

[alrodopial]

Which then activates sheetA code to see theres been a change and calls NewEvent.OpenMarket macro that formats the sheet and sets refresh to 0.2

you can set it to TPD-ON instead of 0.2
Range("Q2")="TPD-ON"