How to classify the values of a matriz

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
F

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?
 
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
 
Does know where I can find?

Michel Walsh said:
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
Click to expand...
 
Sorry, I thought you were asking where you could purchase the VBA
Developer's Handbook Michel was recommending.
 
Back
Top