Simulation game

Question

I'm hoping someone could provide a template/detailed instructions for how to set up a spreadsheet like this one. I have my own parameters and formulas I want to use for determining outputs, but I would like a sequential "guessing game" that records the inputs, ideally with buttons as shown

![](https://learn-attachment.microsoft.com/api/attachments/365f4ab8-6b21-4617-83e9-04a3af99fdbb?platform=QnA

Answer 1

Dear diethyl_ether

1. Create the template in the way you want.
2. Upload the file/workbook to Onedrive, Dropbox, etc ... and share the link here.

3) Then we will create the VBA codes to record the values according to your needs

If you need help with how to upload the file please, click the link below

https://support.office.com/en-us/article/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07

You may also follow the instructions in this video

https://www.youtube.com/watch?v=NnXsE0SNuCc&t=14s

Regards

Jeovany

Answer 2

I'm hoping someone could provide a template/detailed instructions for how to set up a spreadsheet like this one. I have my own parameters and formulas I want to use for determining outputs, but I would like a sequential "guessing game" that records the inputs, ideally with buttons as shown

![Image](https://learn-attachment.microsoft.com/api/attachments/365f4ab8-6b21-4617-83e9-04a3af99fdbb?platform=QnA"https://1drv.ms/x/s!ArrLXMLwfg_GsE-F965qwtFW84BB?e=T71hXp" rel="ugc nofollow">VBA_SimulationGame_11Aug.xlsm

I am learning VBA and reckoned this as an opportunity to Practice My Learnings :-)

RUN EXPERIMENT Button:

- Will take Input Values >> and, at the bottom >> paste in respective columns.

- Write Experiment Number in cell G1.

RESET EXPERIMENT Button:

- Will clear cells B5:F5.

- Will clear all experiments' data at the bottom.

- Will clear cell G1.

CLEAR INPUT VALUES Button:

- Will clear cells B5:F5.

Please respond if You require further assistance. I will try My best to be of help.

If I was able to help You, please mark My response as answer and helpful.

Thank You!