Jump to content

Creating Sudoku checker in Microsoft Excel NO SKILLS in .VBA

- - - - -

  • Please log in to reply
9 replies to this topic

#1
Teabee

Teabee

    Newbie

  • Members
  • Pip
  • 7 posts
I have done it thanks for help

Attached Files


Edited by Teabee, 08 March 2011 - 03:18 PM.


#2
Teabee

Teabee

    Newbie

  • Members
  • Pip
  • 7 posts
nnnnn

Edited by Teabee, 08 March 2011 - 03:18 PM.


#3
WingedPanther

WingedPanther

    A spammer's worst nightmare

  • Moderators
  • 16,831 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others
Do you have anything so far? Do you want to report whether it's impossible, or just wrong based on what you have so far?
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

#4
Teabee

Teabee

    Newbie

  • Members
  • Pip
  • 7 posts
nnnnnnn

Edited by Teabee, 08 March 2011 - 03:18 PM.


#5
WingedPanther

WingedPanther

    A spammer's worst nightmare

  • Moderators
  • 16,831 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others
Start with something simple: when you enter a number, have it check for a duplicate in that number's row, column, and 3x3 subgrid.
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

#6
Teabee

Teabee

    Newbie

  • Members
  • Pip
  • 7 posts
nnnnnnnnnnnn

Attached Files


Edited by Teabee, 08 March 2011 - 03:19 PM.


#7
Teabee

Teabee

    Newbie

  • Members
  • Pip
  • 7 posts
I have attached a code that I made as you requested to do 3x3 subgrid

#8
WingedPanther

WingedPanther

    A spammer's worst nightmare

  • Moderators
  • 16,831 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others
Before you get too far, I do have this book at home: Amazon.com: Programming Sudoku (Technology in Action) (9781590596623): Wei-Meng Lee: Books

Also, please stop posting screenshots and post text. I cannot easily copy/paste/edit an image.

You will probably need to use the Worksheet_change event to capture which cell had a number entered, and then start processing based on that.
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

#9
Teabee

Teabee

    Newbie

  • Members
  • Pip
  • 7 posts
Thanks for the book it is very helpful.

#10
Teabee

Teabee

    Newbie

  • Members
  • Pip
  • 7 posts
nnnnnnnnn

Edited by Teabee, 08 March 2011 - 03:19 PM.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users