Record Values when pressing F9

Hey guys, I need help figuring out how to record a value of a cell whenever F9 is pressed. The cell I want to record the value of is cell D101, which is a sum function of the previous 100 rows. I'd like to figure out a way to run 1,000 trials or so and record the value in cell D101 each time.

Some more details, if needed: I'm simulating a dice game (craps). There are 2 dice, each dice is based off of RANDBETWEEN (1,6) then the dice are added in a different column to achieve the roll. The payout is then based on whatever number was rolled. I'm summing the payout (D101) and would like to run this trial 1,000 times.

I've tried VBA and recording a macro but couldn't figure it out. I've researched a lot but still can't find the answer. Any help?

Thanks.

Thanks Marvin, I appreciate it. That will help me a lot, but honestly, the VBA code is above my understanding right now. I've attached the worksheet I made. It's messy, but basically the value I want to record is D101 on Sheet 2, which I bolded. Is there a quick fix? I don't want to be too time consuming.CrapsPayout.xlsm