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: th-cam.com/video/CeBbTDezuEM/w-d-xo.htmlsi=yy5Hd026dRV_si13
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
![โรงเรียนดัดสันดาน นักเรียนเถื่อน..!! [โรงเรียนไดเม่]](http://i.ytimg.com/vi/vRKPeXn4Fl4/mqdefault.jpg)
![[Full Episode] The Restaurant War Thailand ศึกพ่อค้าซ่าแม่ค้าแซ่บ Episode 4 | 13 ต.ค. 67](http://i.ytimg.com/vi/h8N9tY46P-M/mqdefault.jpg)
you are amazing!
Excelente jogo. Parabéns!
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!
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: th-cam.com/video/CeBbTDezuEM/w-d-xo.htmlsi=yy5Hd026dRV_si13
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