Loop to Find Specific Values

**ks26** · 01-10-2015, 03:06 PM

Hello all, fairly novice with vba programming, especially using loops. I'm hoping someone can provide some help for a problem i'm having.
I have a column with a list of numbers ordered from smallest to largest. These numbers are cut-off values that have a meaning in my work. Users type a value into another part of the worksheet and I use that value to calculate a high and low bound. What i would then like to happen, is for excel to loop through the list of cut off numbers to see if the user's value is below a cut-off and the higher bound is above the cut-off or vice versa: if the user's value is above a cut-off and the lower bound is below a cutoff.

I'm not sure how to write this into VBA can anyone help? Thank you!

**xladept** · 01-10-2015, 06:05 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**ks26** · 01-12-2015, 08:58 AM

Thank you for your reponse! I've attached a sample worksheet as you suggested that contains two scenarios. When the measured value is entered, I would like to have a different message populate in cell K2 depending on the scenario.

Scenario #1: K2 should read "Your measured value is below 3.8, but with uncertainty could be above the 3.8 cut-off"
Scenario #2: K2 should read "Your measured value is above 2.6, but with uncertainty could be below the 2.6 cut-off"

Thank you for your help!Sample Worksheet.xlsx

**xladept** · 01-12-2015, 02:21 PM

Hi KS,

Put this code in your Sheet 1 module and save your book as macro enabled:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

If you haven't used macros before you'll need to go to your options - trust center -trust center settings - macro settings
, the second option down (disable all macros with notification)

Then - Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Click on the Sheet 1 module

then paste the code

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

Loop to Find Specific Values

LinkBack

Thread Tools

Rate This Thread

Display

Loop to Find Specific Values

Re: Loop to Find Specific Values

Re: Loop to Find Specific Values

Re: Loop to Find Specific Values

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Loop and find specific value or misc value, if misc then not equal to certain values

vb find code to find values from specific columns in excel and upload values of same row

Macro Loop to Extract Specific Values and Min/Max Values From Column/Rows Range

Macro Loop – Find Specific Times, Extract Date, Average Values of Times

Need to find specific values in range using loop

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions