Highlight numbers whose sum equals a specific cell value vba

[sofas]

Welcome.
If, for example, I have 10 numbers in a certain column, from A1:A10, for example, in order.


For example, I want to know the sum of the numbers that equal a number in another cell (b2), and let it be 60, so for example, 2 and 58 remain.
5 - 9 - 16 -58 - 2- 6 - 8 - 90 -4 -10

Or, for example, 34 remains 5 -9 - 2 -6 -8 -4

 

[Anthony47]

Try the file that can be downloaded from here: Dropbox
Load your list in sheet "LAVORO" in B2 and downward
Set the Total to search in A4
Set the allowed tolerance in A1 (default is 0.001)
Press the CERCA button; leave the time out to 60 secs and press CERCA on the userform

The found combinations will be shown from column C

 

[sofas]

Very cool idea. I wish the implementation method were without using a userform. It would be enough to press a button, for example