I have already fulfilled my purpose of designing a course to Learn Chess with Excel, both in Spanish and English languages.
♟️ The most difficult thing has been to introduce the basic rules of the game in Excel formulas, no VBA macros!
♟️ What I have not achieved, nor was it my main objective, has been the detection of checkmate, with VBA macros!
Can you help me test it and give me suggestions to improve it?
Last edited by pedrowave; 11-06-2022 at 03:42 AM. Reason: I provide a non-macro version of the file
Welcome to the forum.
If this is a non-macro workbook, then why have you attached an .xlsm file?
Last edited by AliGW; 11-05-2022 at 07:54 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
It is a macro workbook (.xlsm) but the basic rules of the chess game are in Excel formulas!
Regard,
Pedro Wave
Last edited by AliGW; 11-05-2022 at 08:11 AM. Reason: Please DON'T quote unnecessarily!
OK - when you provide a non-macro version of the file, I'll have a look.
I just provided a non-macro version of the file in the first post.
The rules of the movements of the chess pieces are in the sheet 'Rules'.
For example, in the 'Chessboard' sheet there is the position of the pieces at the moment when the white queen checks the black king, which is detected by a macro: TestEnJaque, which is only in the file with macros.
To detect if it is not only check but also checkmate, another macro will be needed that I do not plan to develop at the moment, since it goes beyond the objective that I was pursuing with my template. That's the idea I wanted to convey initially...
AliGW, if you want to detect checkmate, I can explain step by step how I detect check with the macro that manages the 'Rules' sheet.
My main purpose is not to detect checkmate but to detect bugs in the template with macros, and for that it is necessary that many try it and notify me of the bugs they find.
Regards,
Pedro Wave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks