ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sudoku Solver - Help needed.. (https://www.excelbanter.com/excel-programming/372640-sudoku-solver-help-needed.html)

Joe[_46_]

Sudoku Solver - Help needed..
 
Hello All,

I have just been learning to use function in VBA.

I have made a solver for Sudoku Puzzles.. But there are a few issues
which I dont hv much idea about..

I have uploaded the file in the following location.
http://www.esnips.com/web/Sudokusolverbeta

Issue 1: formatting.

i wanted to higlight the user datas from the other datas.. what I did
was, to use conditional formatting to do that.. the problem is that it
takes a lot of time to solve it due to formatting each time during
solving..

One soln could be not to update the values live while being solved..
But i felt that it feels better to see the progress that way.. I
checked without formatting and it takes 1/10th of the time..

My Qn is, is there any suggession to do it in a different way other
than conditional formatting, so that it doesnt consume unnecessary
resources but i get the same effect..


Issue 2:

is it possible to give an option for the user to break the process in
between..


Thanks all for your time..

Regards
Joe.



All times are GMT +1. The time now is 06:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com