VBA - Flow Chart Logic Functions For Small Number Range

[Ourkid123uk]

Hi Guys,

Been along time since been on here and apologies for that.


Im trying to use VBA in Excel to work on a fairly simple flow chart that i have created. I have 5 Variations of the flow chart that i would like to test.

The data set im using is simply a range of numbers from Cell A2:A13. The numbers are to two decimal places.

Because i have 5 variations of testing this number range i decided to Code one and then because it works logically in sequence i can re-arrange the various sections and complete the rest easier.

I need to know whether VBA can use a small range of numbers and perform each Logical Function. If the result is TRUE i would like to then GOTO another section if FALSE another section or possibly just to display "FALSE"


Here are the Six Logical Function Tests i would really appreciate some help with;



1) Does the range (A2:A13) contain any duplicate numbers - if yes display FALSE in Cell D9, if no GOTO next Logical Test

2) Are 4 or more of the numbers in the range between 1.00 and 1.99 & are there 0 numbers between 2.00-2.99 - if yes display FALSE in Cell D9, if no GOTO one of the other Logical Tests below

3) Are there any numbers in the range between 1.50-2.00 - if yes GOTO a specified Logical Test, if no GOTO a different specified Logical Test

4) Are there any numbers in the range between 2.50-2.80 - if yes GOTO a specified Logical Test, if no GOTO a different specified Logical Test

5) Are there specifically 3 to 5 numbers in the range between 1.00-1.99 - if yes GOTO a specified Logical Test, if no GOTO a different specified Logical Test

6) Are 6 or more numbers in the range between 1.00-1.99 - if yes GOTO a specified Logical Test, if no GOTO a different specified Logical Test



Basically once im able to code the logic funtions for each stage and know how to then either Display Text to a certain Cell or be re-directed to another logical function i can piece all my Flow Chart Variations togther, if that makes sense?


I know this is a big ask guys & honestly ANY help is greatly appreciated! Ive spent over 6 months using complex Excel Cell Logic Funtions and i believe that using a Flow Chart Style system and VBA i could have all these done in a couple of hours. The problem is the intital 6 Logic Funtion Test Code followed by either been directed to another defined Logic Test Code (using predefined names?) or displaying so text (say "FALSE") in a certain Cell (Say D9).

Im sure i will be able to re-work everything to make the 5 Variations if i know the VBA code for the above 6 Tests.


Again, REALLY appriciate any help at all...


Thank you for taking your time to read,

Andi