+ Reply to Thread
Results 1 to 2 of 2

Populate Texbox based from Combobox selection having applied dynamic range and adv filter

  1. #1
    Registered User
    Join Date
    08-18-2017
    Location
    Leicester, England
    MS-Off Ver
    Office 2013 & 365
    Posts
    54

    Populate Texbox based from Combobox selection having applied dynamic range and adv filter

    Hello

    I'm new to VBA and in all honesty have been searching the net and following instructions and copying codes to suit. However, I can't seem to find anything that helps me populate a textbox from the combobox selection. I have a userform with:
    First cbx with a rowsource of a dynamic range of a list of suppliers "SupList". Once supplier is selected, I have an advance filter macro. 2 of the columns in this macro shows part numbers and part description for this supplier. I have applied a dynamic range name for these 2 columns "SupPartFilter". This is followed by a delete duplicate macro that only shows unique part numbers only. This seems to work fine.
    Second cbx populates with the unique part numbers for the supplier. This works fine too.
    Third is a textbox which I would like to populate with the part description but this is where I am struggling. I have tried various suggestions but can't get anything to work:

    Please Login or Register  to view this content.
    Would appreciate any help with this so that I can move on to the stage.
    Regards
    Amita

  2. #2
    Registered User
    Join Date
    08-18-2017
    Location
    Leicester, England
    MS-Off Ver
    Office 2013 & 365
    Posts
    54

    Re: Populate Texbox based from Combobox selection having applied dynamic range and adv fil

    Hi
    Just updating this thread as solved. I adjusted my code and it worked:

    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. Replies: 1
    Last Post: 06-30-2016, 11:54 AM
  2. [SOLVED] Code required to Auto Populate 3rd Combobox based on 02nd Combobox Selection
    By bimmy80 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-14-2015, 03:56 AM
  3. Populate Combobox based on Selection in another Combobox
    By DomSza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2015, 08:19 AM
  4. [SOLVED] How do I populate a specific range in one ComboBox based of selection of another ComboBox?
    By gmr4evr1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-04-2015, 04:32 PM
  5. [SOLVED] populate user form combobox based on dynamic range
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2015, 09:22 PM
  6. Populate textbox based off ComboBox Selection
    By ladams41 in forum Excel General
    Replies: 1
    Last Post: 04-09-2014, 10:13 AM
  7. Userform Combobox to populate based on selection in another combobox
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2014, 03:34 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