@ spreadbetting: This looks like something I could easily implement when I get the first draft of the template complete to make it more efficient! I will do some research!!
@nigelk: I like how the first line of code is a way of cutting the code short, I could use this if the letter or some other condition remains the same to make it more efficient.
I’ve created a new draft template and to be fair, it ALMOST works perfectly!
BetAngel_Cal_Template.xls
Cell B31 is the ActionCell (You can see how it works via cells B34 and B37 simply enough), J32 is the StateCell and O9 is the BAActionCell.
For some reason it skips over Case “J” which is the error identifier and for some reason it doesn’t do the ‘Lay’ side of instructions?
If you Type A in J32 and make the ActionCell show “BACK” then it will transition from B to C, type ”PLACED” in O9 (D) and then make the ActionCell show “LAY” (E) and type “PLACED” again in O9 to loop back round to (A). This shows that it is successfully launching sub LayOne so there’s no problems there BUT if you try and do the inverse:
Start at (A) and type “LAY” in the ActionCell (Should go to (F)) nothing happens?
Also the code doesn’t recognise:
Code: Select all
Case "B"
If StateCell = "B" Then
Call BackOne
If StateCell = "B" Then
StateCell = "C"
End If
End If
So instead I’ve had to use:
Code: Select all
Case "B"
If Worksheets("Bet Angel").Range("J32").Value = "B" Then
Call BackOne
If Worksheets("Bet Angel").Range("J32").Value = "B" Then
Worksheets("Bet Angel").Range("J32").Value = "C"
End If
End If
Any way of making this tidier? After this bug is fixed the spreadsheet will be ready to share so other members can run repeated automated strategies via the spreadsheet that dynamically reloads and help me look for possible bugs.
This has proven to be more frustrating than I originally thought it would be.
Callum.
You do not have the required permissions to view the files attached to this post.