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.
@ExcelMacroMania
2 жыл бұрын
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.
@ricardoricric
2 жыл бұрын
@@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!
@thebutcher7541
7 ай бұрын
How can you lock the whole page without locking the start buttons??? Please help
@ExcelMacroMania
7 ай бұрын
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.
@RILEX_N1
2 ай бұрын
7:24
@israahassan602
8 ай бұрын
is it possible to beat it?
@ExcelMacroMania
8 ай бұрын
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
@alvarezmialmaalan8520
Жыл бұрын
Pero no lo terminas?
@ExcelMacroMania
Жыл бұрын
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
@verizonextron
6 ай бұрын
theres no "developer" in my excel lol
@ExcelMacroMania
6 ай бұрын
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: kzitem.info/news/bejne/pJt4yIh6nqymeIIsi=yy5Hd026dRV_si13
Пікірлер: 15