+ Reply to Thread
Results 1 to 2 of 2

Dynamic vendor contact userform with multiple comboboxes

  1. #1
    Registered User
    Join Date
    10-17-2014
    Location
    Wausau, WI
    MS-Off Ver
    2014
    Posts
    17

    Question Dynamic vendor contact userform with multiple comboboxes

    I am relatively new to VBA and was wondering if it were possible to have a Userform that, when opened, allows the user to type a Vendor's Company, Employee Name, Email, and Phone Number. This will then send it to a worksheet with a growing list of vendor information in a table.
    On another sheet I have a Userform that has two Comboboxes; one that has a list of company names and the other with the corresponding employee(s). When you pick a Company from the first Combobox the second Combobox can ONLY display contacts from that company. After the employee is chosen, a form on the spreadsheet is filled out with the employee's Company, Name, Email, etc.
    Overall I am just looking for a way to easily add contacts to a spreadsheet without having to type all the information in every time or having to sift through 300 vendor names to find the employees of a specific company. I am hoping to be able to end up with one table with company and employee information and on the other spreadsheet a Userform that has two dropdowns with the second only being relative to the first one.

  2. #2
    Registered User
    Join Date
    10-17-2014
    Location
    Wausau, WI
    MS-Off Ver
    2014
    Posts
    17

    Re: Dynamic vendor contact userform with multiple comboboxes

    I found and modified this: http://www.onlinepclearning.com/exce...er-excel-2010/ to suit my needs. this works perfectly and is very user friendly.

+ 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: 13
    Last Post: 10-20-2019, 05:39 AM
  2. Multipying Multiple ComboBoxes on a Vba userform
    By smurfdjman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2013, 06:52 PM
  3. [SOLVED] Cascading Comboboxes With Multiple Dynamic Named Ranges?
    By spamad in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-20-2013, 10:52 AM
  4. [SOLVED] Multiple dynamic Comboboxes in UserForm
    By joehjas in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-17-2012, 03:43 AM
  5. UserForm with Multiple ComboBoxes Populate
    By RobertCo in forum Excel General
    Replies: 2
    Last Post: 12-27-2006, 01:51 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