+ Reply to Thread
Results 1 to 3 of 3

Get value from control dropdowns

  1. #1
    Forum Contributor
    Join Date
    03-14-2015
    Location
    Mexico
    MS-Off Ver
    365
    Posts
    285

    Get value from control dropdowns

    Hi I need to import data from one sheet to another based on the information listed in a Form Control (dropdown) however I has not been able to do it with this code.

    Any idea?

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,658

    Re: Get value from control dropdowns

    The dropdown .Value is the list index number of the selected item.

    Try this...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    03-14-2015
    Location
    Mexico
    MS-Off Ver
    365
    Posts
    285

    Re: Get value from control dropdowns

    Thank you so much, it worked!

+ 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. [SOLVED] VBA for dropdowns based on another dropdowns
    By abhi_jain80 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-15-2016, 05:14 AM
  2. How to use form control dropdowns to list items based on a condition
    By ssraj in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-16-2014, 07:08 AM
  3. Dropdowns
    By excelinho in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-11-2013, 02:59 PM
  4. Excel 2007 : filtering dropdowns with dropdowns?
    By CADiphile in forum Excel General
    Replies: 2
    Last Post: 10-15-2009, 04:11 PM
  5. Help with dropdowns
    By srs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2008, 04:57 AM
  6. Dropdowns and possible "sub dropdowns
    By LeonidasSaveUs! in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2008, 09:55 PM
  7. DropDowns
    By Dharsh in forum Excel General
    Replies: 2
    Last Post: 04-28-2005, 08:06 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