For developer tab Go to file (in excel ) Click on options tab Then go to customize ribbon Then click on popular commands Then click on main tabs Then select developer tab Then click (okkkk)
Can you create a just "do" loop, without the "while" or "until"?? I cant do it in my VBA as you did on your game [at 7:00 on your vid]. Can you help me? Thanks and also thanks for the nice videos and tutorials.
Yes, you can create a Do loop without While or Until (as shown in the video). However, you need to be careful and add some condition to exit the loop because otherwise it will be an infinite loop and most probably freeze the application. You can exit the loop with "Exit Do" when the condition is met.
@@ExcelMacroMania Thanks! It worked! Previously to my question I tried a Do without while or until but Excel didnt allow me. Maybe I did something wrong that time, but now I tried again with a different code (similar to the one on your video) and worked. Thanks!
Right-click the buttons or shapes, go to properties if it's a shape or format control if it's a command button and untick the property "Locked". Then you can protect the worksheet while buttons are unlocked. The same applies to any other components in Excel.
In general, winning tic tac toe is impossible if both players make perfect moves. The algorithm I used is explained in more detail in my blog and is just doing that, perfect moves, so that you cannot really win. You are smart enough is you just don't lose 🙂 And of course, you can modify the code to create easier levels, the easiest probably leaving the computer make completely random moves as I show first in the video. Here's the post with more details: excelmacrofun.blogspot.com/2021/11/excel-tic-tac-toe.html
You need to add the developer tab to the ribbon, it's explained in this introduction video, somewhere towards the middle or end of the video: ruclips.net/video/CeBbTDezuEM/видео.htmlsi=yy5Hd026dRV_si13
@@Alinka05663 Click on "Ribbon Display Options" on the top-right corner of Excel to show, hide, etc, or press Ctrl + F1. You can also do it with VBA - CommandBars.ExecuteMso "HideRibbon"
@@Alinka05663 Maybe the macro has a line to hide the ribbon. You can show it again manually from the upper right corner of Excel or using this line of VBA code (and/or remove this line in the macro, this is the one that hides the ribbon): CommandBars.ExecuteMso "HideRibbon" Or if it's minimized only: CommandBars.ExecuteMso "MinimizeRibbon"
Se estaba haciendo el video un poco largo ya, y es algo complicado de explicar. Pero si hay interes puedo hacer otro video explicando el algoritmo. Tambien puedes ver la explicacion y bajar el archivo en mi blog: excelmacrofun.blogspot.com/2021/11/excel-tic-tac-toe.html
you are amazing!
Can you please do a full video tutorial on how to do all the following steps from the blog? :)
I will do, it's on my list already, probably will publish here in 2-3 months time.
@ExcelMacroMania awesome! :) Thank you
For developer tab
Go to file (in excel )
Click on options tab
Then go to customize ribbon
Then click on popular commands
Then click on main tabs
Then select developer tab
Then click (okkkk)
Can you create a just "do" loop, without the "while" or "until"?? I cant do it in my VBA as you did on your game [at 7:00 on your vid]. Can you help me? Thanks and also thanks for the nice videos and tutorials.
Yes, you can create a Do loop without While or Until (as shown in the video). However, you need to be careful and add some condition to exit the loop because otherwise it will be an infinite loop and most probably freeze the application. You can exit the loop with "Exit Do" when the condition is met.
@@ExcelMacroMania Thanks! It worked! Previously to my question I tried a Do without while or until but Excel didnt allow me. Maybe I did something wrong that time, but now I tried again with a different code (similar to the one on your video) and worked. Thanks!
Excelente jogo. Parabéns!
How can we save though??? I just lost my program 😭
How can you lock the whole page without locking the start buttons??? Please help
Right-click the buttons or shapes, go to properties if it's a shape or format control if it's a command button and untick the property "Locked". Then you can protect the worksheet while buttons are unlocked. The same applies to any other components in Excel.
is it possible to beat it?
In general, winning tic tac toe is impossible if both players make perfect moves. The algorithm I used is explained in more detail in my blog and is just doing that, perfect moves, so that you cannot really win. You are smart enough is you just don't lose 🙂
And of course, you can modify the code to create easier levels, the easiest probably leaving the computer make completely random moves as I show first in the video. Here's the post with more details:
excelmacrofun.blogspot.com/2021/11/excel-tic-tac-toe.html
theres no "developer" in my excel lol
You need to add the developer tab to the ribbon, it's explained in this introduction video, somewhere towards the middle or end of the video: ruclips.net/video/CeBbTDezuEM/видео.htmlsi=yy5Hd026dRV_si13
@@ExcelMacroMania I have not the ribbon why
@@Alinka05663 Click on "Ribbon Display Options" on the top-right corner of Excel to show, hide, etc, or press Ctrl + F1. You can also do it with VBA - CommandBars.ExecuteMso "HideRibbon"
@@Alinka05663 Maybe the macro has a line to hide the ribbon. You can show it again manually from the upper right corner of Excel or using this line of VBA code (and/or remove this line in the macro, this is the one that hides the ribbon):
CommandBars.ExecuteMso "HideRibbon"
Or if it's minimized only:
CommandBars.ExecuteMso "MinimizeRibbon"
Pero no lo terminas?
Se estaba haciendo el video un poco largo ya, y es algo complicado de explicar. Pero si hay interes puedo hacer otro video explicando el algoritmo. Tambien puedes ver la explicacion y bajar el archivo en mi blog: excelmacrofun.blogspot.com/2021/11/excel-tic-tac-toe.html
7:24