+ Reply to Thread
Results 1 to 2 of 2

Need to Populate a Text box with a named range based on a value in a Dropdown Box.

  1. #1
    Registered User
    Join Date
    03-08-2014
    Location
    Whyalla
    MS-Off Ver
    Excel 2003
    Posts
    43

    Need to Populate a Text box with a named range based on a value in a Dropdown Box.

    Hi people

    I have a Need to Populate a Text box with a named range based on a value in a Dropdown Box. We are replacing a Workbook that has become over crowded with information and I would like to make a kind of lookup table based on the value in a dropdown box. I have all the information I require in identicle sized ranges the trouble is how do I get it to add to a text box.

    Thanks in Advance

    Bob

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,137

    Re: Need to Populate a Text box with a named range based on a value in a Dropdown Box.

    To Populate 100 Text Boxes.

    Please Login or Register  to view this content.

    To Save 100 Text Boxes.

    Please Login or Register  to view this content.

+ 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] Dynamic Named Range to Auto-Populate another range based on criteria
    By BeachRock in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-24-2014, 06:46 PM
  2. [SOLVED] Loop through named range backwards and populate based on criteria from adjacent cells
    By CDEG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2013, 05:56 AM
  3. [SOLVED] Populate Range with Text based on cell value
    By bcn1988 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2012, 12:35 PM
  4. Want to populate email fields FROM, TO, CC, Subject based on a named range
    By mbhc77 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-29-2012, 12:24 PM
  5. Y Axis data source changes based on the Named range listed in Dropdown
    By aravindhan_31 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-09-2012, 12:43 AM

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