At work, I've been tinkering aorund with Excel, trying to expand my knowledge of it by trying to make the basics of a little PvP type fight game. ;)
Just the bare basics atm, I've got a field with a validated list of 1 to 10 for attack and defense (twice, once for the attacker and defender). Next to these are 10 columns that choose a random number from 1-10, a number of times from 1 to 10. If that makes sense!
So the first cell is a random number from 1-10. The next creates two random numbers both form 1-10, the third cell 3, and so on.
Below these, I choose the maximum result from each of the random numbers created. ;)
This forms an Attack and Defend score, which generates damage done.
I have bound a Macro to a button to recalculate the forumla each time it's clicked, to simulate another roll of the dice, so to speak.
But now I've come to a slight dead end.
The next thing I want to do is record damage done.
But I can't figure out a way to store the results done. If that makes sense as well!
Starting with 'Hit Points' of 100, I can reduce this amount by the damage done each click of the macro. But it will always reset back.
I can't figure out a way to store the result in Excel.
Does anyone have any ideas/suggestions?