+ Reply to Thread
Results 1 to 1 of 1

Load Userform ComboBox with filtered data

  1. #1
    Registered User
    Join Date
    11-15-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    97

    Load Userform ComboBox with filtered data

    Hi,

    I am building a userform in which I need to capture the customer's name from a sheet given in the example worksheet.

    I have two categories of customers. Those appearing in the Master have a value > 0 in the Customer Code (column F) column. If the customer does not appear in the Master then the customer code has a value of zero and the name is entered.

    For the userform (UserForm1) that I am building, I have a textbox for the customer code. If the customer code > 0, then I look up the master and fill in the customer's name. If the customer code is zero, then I want to load all the unique customer name for which the customer code is 0 so that the user can select from this list.

    I have two problems that need help on:

    a) if I provide a combobox for the customer name, can I fill the customer name in the combobox

    b) can someone help with the vba code to load the unique customer name for customer code = 0 into the combobox

    Regards,

    Anand
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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