Käynnissä

Excel VBA Logical Functions With GOTO Lines to Seperate

Im using 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 eventually test as part of my larger project.

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 flow chart 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.

Its just using general Logic Functions. 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 require you to complete

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 i have the logic funtions coded for each stage i can piece all my Flow Chart Variations togther using a GOTO command, if that makes sense?

If you could clearly show the Logical Funtions above seperated and with a GOTO Line Number at the start of each one i can use this to work with my drawn flow charts.

Does this make sense? If you require more information im happy to talk you through some more of what i require.

Regards,

Andrew

Taidot: tietojenkäsittely, Excel, Excel Macros, Excel VBA, Visual Basic

Näytä lisää: excel 2013 power programming with vba pdf, excel 2013 power programming with vba mr spreadsheet's bookshelf, excel 2010 power programming with vba pdf, excel 2010 power programming with vba mr spreadsheet's bookshelf, excel vba with, microsoft excel 2013 power programming with vba free, excel 2013 power programming with vba, excel 2010 power programming with vba mr spreadsheets bookshelf, excel 2010 power programming with vba, sql server user defined functions call excel vba, excel vba delete lines keywords, date range functions excel vba, java thru excel vba functions, excel vba optimization functions, build excel vba functions

Tietoa työnantajasta:
( 0 arvostelua ) Dudley, United Kingdom

Projektin tunnus: #16097158

1 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_23% %project_currencyDetails_sign_sub_24% tähän työhön

insidenetsoft

Hired by the Employer

£150 GBP 3 päivässä
(26 arvostelua)
4.4