GO: trigger

[danjuma]

Gary,

How does one use the GO: trigger?

Can it just be entered into cell Q2 for example: =GO: sheet1!N3, which doesn't seem right to me, or does it have to be used via VBA? If via VBA, how? When I tried for example: Range("Q2").Value = GO: Range("Q1").Value, (where Q1 value =sheet1!N3), I get a compile error, invalid use of property.

Thanks

[Shaun]

When i was using it you would put in the race ID you wanted to switch to, i used to use a Look on to a sheet where i had collected all the race ID for the days like this.

Code: Select all

Kyne (AUS) 6th Dec - 10:00 R1 1212m Mdn               100413293
Kyne (AUS) 6th Dec - 10:35 R2 1212m 3yo               100413295
Kyne (AUS) 6th Dec - 11:10 R3 1469m Mdn               100413297
Kyne (AUS) 6th Dec - 11:45 R4 1469m Mdn               100413299
Kyne (AUS) 6th Dec - 12:20 R5 1212m Hcap               100413301
Kyne (AUS) 6th Dec - 12:55 R6 1875m Hcap               100413303
Kyne (AUS) 6th Dec - 13:35 R7 1469m Hcap               100413305

When my sheet switched to a race it would look up the race name then display the race ID in a cell, i would combine this with the ="GO:"&control!k1

[danjuma]

When i was using it you would put in the race ID you wanted to switch to, i used to use a Look on to a sheet where i had collected all the race ID for the days like this.

Code: Select all

Kyne (AUS) 6th Dec - 10:00 R1 1212m Mdn               100413293
Kyne (AUS) 6th Dec - 10:35 R2 1212m 3yo               100413295
Kyne (AUS) 6th Dec - 11:10 R3 1469m Mdn               100413297
Kyne (AUS) 6th Dec - 11:45 R4 1469m Mdn               100413299
Kyne (AUS) 6th Dec - 12:20 R5 1212m Hcap               100413301
Kyne (AUS) 6th Dec - 12:55 R6 1875m Hcap               100413303
Kyne (AUS) 6th Dec - 13:35 R7 1469m Hcap               100413305

When my sheet switched to a race it would look up the race name then display the race ID in a cell, i would combine this with the ="GO:"&control!k1

Thanks for the reply Shaun. I take the formula in your example, ="GO:"&control!k1, goes into cellQ2?

[danjuma]

Does not seem to work for me. The formular keeps being deleted from cell Q2. Gary any solutions/suggestions, or how this is used in a VBA code? Thanks

[GaryRussell]

Gary,

How does one use the GO: trigger?

Can it just be entered into cell Q2 for example: =GO: sheet1!N3, which doesn't seem right to me, or does it have to be used via VBA? If via VBA, how? When I tried for example: Range("Q2").Value = GO: Range("Q1").Value, (where Q1 value =sheet1!N3), I get a compile error, invalid use of property.

Thanks

I recommend using VBA as the formula will just get overwritten.
The code in your example may work if you change it to read as follows.

Code: Select all

Range("Q2").Value = "GO:" & Range("Q1").Value

or a shortened version would be as follows which I think is more readable. Both mean the same thing.

Code: Select all

[Q2] = "GO:" & [Q1]

[Shaun]

Sorry about that, i should have mentioned that you need to use VBA to pick up the finished product

[danjuma]

Gary,

How does one use the GO: trigger?

Can it just be entered into cell Q2 for example: =GO: sheet1!N3, which doesn't seem right to me, or does it have to be used via VBA? If via VBA, how? When I tried for example: Range("Q2").Value = GO: Range("Q1").Value, (where Q1 value =sheet1!N3), I get a compile error, invalid use of property.

Thanks

I recommend using VBA as the formula will just get overwritten.
The code in your example may work if you change it to read as follows.

Code: Select all

Range("Q2").Value = "GO:" & Range("Q1").Value

or a shortened version would be as follows which I think is more readable. Both mean the same thing.

Code: Select all

[Q2] = "GO:" & [Q1]

Thanks Gary. Your suggestion works.

[danjuma]

Sorry about that, i should have mentioned that you need to use VBA to pick up the finished product

No probs Shaun. Thanks for your assistance.