How to classify the values of a matriz

[Frank Dulk]

How to classify the values of a matriz, for instance,

Dim MinhaMatriz(10) as integer

After defining the values for the head office, how to come back the data in
growing order?

Does have to be in the arm?

 

[Michel Walsh]

Hi,


You have to sort the value (in ascending or descending order) using a
VBA algorithm, since VBA does not have "template" (C++) which would
consider the array as an object by itself ( as in dotNet ) on which you can
use the method "Sort". So, you have to produce your own function that take
an array as input and return a sorted array for output. QuickSort algorithm,
on Google, should return many hits. VBA Developer's Handbook, at Sybex, by
Ken Getz, also has such a method.



Hoping it may help,
Vanderghast, Access MVP

 

[Frank Dulk]

Does know where I can find?

Hi,


You have to sort the value (in ascending or descending order) using a
VBA algorithm, since VBA does not have "template" (C++) which would
consider the array as an object by itself ( as in dotNet ) on which you can
use the method "Sort". So, you have to produce your own function that take
an array as input and return a sorted array for output. QuickSort algorithm,
on Google, should return many hits. VBA Developer's Handbook, at Sybex, by
Ken Getz, also has such a method.



Hoping it may help,
Vanderghast, Access MVP

 

[Douglas J. Steele]

http://www.developershandbook.com/

 

[Frank Dulk]

But as I find the function

http://www.developershandbook.com/

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



using

 

[Michel Walsh]

HI,


Well, there are also useful VB web sites, like VBnet (nothing to do with
dotNet): http://vbnet.mvps.org/index.html?code/sort/index.html



Vanderghast, Access MVP

 

[Frank Dulk]

thank you

HI,


Well, there are also useful VB web sites, like VBnet (nothing to do with
dotNet): http://vbnet.mvps.org/index.html?code/sort/index.html



Vanderghast, Access MVP

 

[Douglas J. Steele]

Sorry, I thought you were asking where you could purchase the VBA
Developer's Handbook Michel was recommending.