+ Reply to Thread
Results 1 to 2 of 2

Problem with populating text boxes with filtered data

  1. #1
    Forum Contributor
    Join Date
    07-23-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    211

    Problem with populating text boxes with filtered data

    Hi

    I have the following code to :

    1 Filter data
    2 Sort the filtered data
    2 Populate a number of textboxes with the sorted & filtered data

    The data is being filtered but not sorted and not populating the text boxes with only the filtered data.

    Can someone help me understand what I am doing wrong?

    Thanks

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    07-23-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    211

    Re: Problem with populating text boxes with filtered data

    Hi again

    This part of the code (to populate the textboxes) is reading the hidden cells rather than only the filtered data.

    Can someone advise how I can get the code to read only the filtered or visible cells only?

    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. Selected data from combo boxes to text boxes
    By soulun in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-22-2013, 06:48 AM
  2. [SOLVED] Populating text boxes from a combo box choice
    By adam.hewitt5 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-27-2012, 01:15 PM
  3. Populating multiple text boxes from different workbook sheets vb
    By kants83 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2010, 08:11 PM
  4. [SOLVED] Auto populating UserForm Combo and Text boxes from Validated data sets
    By ZIXILPLIX in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2010, 12:55 AM
  5. User Form Basics - Populating Text Boxes
    By T.J. Lanza in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-24-2009, 03:48 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