+ Reply to Thread
Results 1 to 5 of 5

How to find lowest to greatest of 3 values/variables? (Not using workbook formulas)

Hybrid View

  1. #1
    Registered User
    Join Date
    03-15-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    63

    How to find lowest to greatest of 3 values/variables? (Not using workbook formulas)

    I have 3 variables that are integers. I am needing to find the values placement from lowest to highest. I've done a lot of research, but everyone is using WorkbookFunction to achieve the results. I am using a userform and therefore don't want to have to use WorkbookFunction. Any ideas? Thanks.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: How to find lowest to greatest of 3 values/variables? (Not using workbook formulas)

    Any special reason you don't want to use the WorkBookFunction? It's part of Excel and there's nothing wrong with that.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    03-15-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    63

    Re: How to find lowest to greatest of 3 values/variables? (Not using workbook formulas)

    Quote Originally Posted by Keebellah View Post
    Any special reason you don't want to use the WorkBookFunction? It's part of Excel and there's nothing wrong with that.
    I don't want to have to rely on cells when I am using this userform.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: How to find lowest to greatest of 3 values/variables? (Not using workbook formulas)

    A WorkbookFunction does not imply a cell, it's the way you refer to Excel's internal Functions which can be used in formulas.
    You address these functions like WorkbookFunction.Max in VBA while in a formula you just use MAX, thes same with VLOOKUP etc.

    Since I have nothing to go on to help you (no sample file) that's all I can di for you for now.

  5. #5
    Registered User
    Join Date
    03-15-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    63

    Re: How to find lowest to greatest of 3 values/variables? (Not using workbook formulas)

    Quote Originally Posted by Keebellah View Post
    A WorkbookFunction does not imply a cell, it's the way you refer to Excel's internal Functions which can be used in formulas.
    You address these functions like WorkbookFunction.Max in VBA while in a formula you just use MAX, thes same with VLOOKUP etc.

    Since I have nothing to go on to help you (no sample file) that's all I can di for you for now.
    Thanks. That answers enough. I thought that the WorksheetFunction method affected/called the cells directly. I couldn't find much answers on using it for pre-stored variables so its good to know that it will work fine with variables.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] returning greatest and lowest value involving index match formula
    By bridge4444 in forum Excel General
    Replies: 6
    Last Post: 08-10-2016, 07:04 PM
  2. Find the 5 lowest values
    By jacko53 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-18-2014, 08:30 AM
  3. [SOLVED] Search list find two greatest values
    By quickheart in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-23-2013, 07:16 AM
  4. Replies: 1
    Last Post: 07-27-2012, 02:37 PM
  5. Replies: 13
    Last Post: 07-09-2012, 11:38 AM
  6. Replies: 12
    Last Post: 11-16-2009, 09:13 PM
  7. [SOLVED] How do I find the two lowest values in a range?
    By dlroelike in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2005, 09:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1