+ Reply to Thread
Results 1 to 2 of 2

Return specific value from a named range in a userform

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Return specific value from a named range in a userform

    Hi is it possible to return the first value from a named range in a textbox on a userform?

    Currently I am using this code to return a list to choose from, I am testing a way to do this with FLOWRAP


    Please Login or Register  to view this content.
    What I want to do is for this example there are 8 values in the named range "FLOWRAP"

    In textbox95 I want to return the first value in that named rang, box96 the 2nd, box 97 the 3rd and so on........

    is this possible, if so what do I need to put in my code
    Please Login or Register  to view this content.
    Any help is great as I cant find anything to help me searching the internet!

    Thanks

    Dan

  2. #2
    Forum Contributor
    Join Date
    05-27-2014
    Location
    Belfast, Northern Ireland
    MS-Off Ver
    2007 & 2010
    Posts
    273

    Re: Return specific value from a named range in a userform

    How about this:
    Please Login or Register  to view this content.
    Last edited by kadeo; 09-03-2015 at 12:21 PM.
    Please click *Add Reputation if I've helped

+ 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. How to Return a Named Range
    By MightyMack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-11-2014, 12:49 PM
  2. [SOLVED] Used named range in listbox on userform
    By WilliamWu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2013, 08:04 AM
  3. [SOLVED] Determine what Named Range the Target Address is and return Named Range Name
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2012, 10:49 PM
  4. listbox populating on userform with named range
    By kmsoni in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2011, 01:37 PM
  5. listbox populating on userform with named range
    By kmsoni in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2011, 02:31 PM
  6. INDEX several named tables to return a specific value in the table
    By FunkyDragon in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-29-2010, 05:54 PM
  7. Dyn Named Range update from userform
    By KD in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-07-2006, 04:20 PM

Tags for this Thread

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