Excel VBA Button Help

Try this
(vba checks from bottom to top to see if button contains text and runs the code for the first button it finds which contains no text)
The code for each of the top row buttons need modifying in the same way

Please Login or Register  to view this content.

Hello rdroy1954,

This is a late answer to your post but I hope you will find it useful. The attached workbook has your User form with a modification. Each vertical column has two player buttons "X" an "O". There are 12 total. When the user clicks a button that player's mark is added to the next cell in that column. After each player makes a choice, the macro checks for a win.

I basically rewrote the code. While your code was working, it lacked the flexibility to accommodate the new changes. You will see this code uses a variety of techniques to simply the and streamline the code. If you were to turn this in as your own project, it would be obvious you had help. My goal is help you see and learn new ways of solving problems with VBA. The code is heavily documented but I am sure you will still have some questions. Please don't hesitate to ask me anything you have a question about.

Here is the User Form code. The attached workbook contains the new changes and this code.

Please Login or Register  to view this content.