Results 1 to 4 of 4

User Form Dependent Dropdown (ComboBox)

Threaded View

tmleynek User Form Dependent Dropdown... 10-15-2015, 08:53 AM
gmr4evr1 Re: User Form Dependent... 10-15-2015, 10:08 AM
tmleynek Re: User Form Dependent... 10-15-2015, 12:17 PM
gmr4evr1 Re: User Form Dependent... 10-15-2015, 04:45 PM
  1. 10-15-2015, 04:45 PM #4
    gmr4evr1 is offline
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: User Form Dependent Dropdown (ComboBox)

    If the list is in column A rows 1 - 10, then you could use Range("A1:A10"). So, it would look like this...
    If ComboBox1.Value = "TypeA" Then 
ComboBox2.List = .Range("A1:A10").Value
    Last edited by gmr4evr1; 10-15-2015 at 04:50 PM. Reason: Corrected code...I had forgetten the .List
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. User selects a value from dropdown list and the dependent values gets autopopulated
    By biju_u in forum Excel General
    Replies: 10
    Last Post: 05-30-2015, 01:33 PM
  2. Dependent list boxes in user form
    By jockey17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2014, 03:43 PM
  3. Calling a user form initialize sub when entering the form to populate combobox...
    By regupnorth in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-02-2012, 07:24 AM
  4. Dropdown Combobox dependent on another
    By loknath in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2012, 05:08 AM
  5. Dependent Combobox on Form not updating from dynamic range
    By ron2k_1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2011, 12:59 PM
  6. Transfer User form data to a worksheet w.r.t. combobox item on the form
    By nm766 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2011, 12:43 PM
  7. transferring combobox value from one user form to populate combobox on another
    By smartphreak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2010, 10:12 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1