+ Reply to Thread
Results 1 to 2 of 2

Connecting named range with ComboBox

  1. #1
    Registered User
    Join Date
    04-04-2014
    Location
    Warsaw
    MS-Off Ver
    Excel 2010
    Posts
    97

    Connecting named range with ComboBox

    Hello,
    I've got following problem. I want to make simple Combobox with two dropdown lists throwing me back cells values, but I never made that so I've got a little difficulties.

    The sample combobox should look like this:
    Clipboard01.png

    For the left Dropdown list there's defined name of the range "ITEM1", and for the second - range named "ITEM2".
    After user will choose something I want to have numbers of the items selected from the lists in cells "A1" and "A2", and run a macro after clicking OK. How can I do this?

    Thanks in advance for help!

    Regards

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Can you upload a sample workbook?
    If posting code please use code tags, see here.

+ 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. Need to add items to a named range for a combobox
    By rbpd5015 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2014, 08:29 PM
  2. [SOLVED] ComboBox add entry to Named Range if not in list
    By pjbassdc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2014, 03:36 PM
  3. activex combobox and dynamic named range
    By lcsw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2013, 05:30 PM
  4. [SOLVED] Populate combobox named range
    By zardof in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2012, 04:00 AM
  5. Setting ComboBox.RowSource via Named Range
    By RobertL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2007, 08:19 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