ExcelCosby
New Member
- Joined
- Jan 25, 2015
- Messages
- 2
Hello everyone! I've recently been using Excel 2013 on my free time and I wanted to create a Slot Machine. I've used RANDBETWEEN, IF and COUNTIF to display a price in cell L11 if three cells below it have the same words in them. It's working properly but my main problem has been with macros, since I know very little about them.
What I want to do is have a cell (for example, L9) that displays your total money. When you press a macro button, it subtracts 10 from the total money. If the price (L11) displays, for example, "10€" then I want it to add 10 to the total money. If the price displays a bigger price, it adds that to the total money.
I know you have to use VBA for this but since I don't know anything about it, I'd appreciate any help that I can get. Thanks!
What I want to do is have a cell (for example, L9) that displays your total money. When you press a macro button, it subtracts 10 from the total money. If the price (L11) displays, for example, "10€" then I want it to add 10 to the total money. If the price displays a bigger price, it adds that to the total money.
I know you have to use VBA for this but since I don't know anything about it, I'd appreciate any help that I can get. Thanks!