+ Reply to Thread
Results 1 to 2 of 2

Variable for named range in combobox

  1. #1
    Registered User
    Join Date
    04-01-2016
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    56

    Variable for named range in combobox

    A very kind person has given me some wonderful code that I have been using to add information to a named range.

    I'm just missing one thing, and that is having the named range(s) selected from the userform. There is a combobox from which the user selects an option, and this then selects the correct named ranges to insert it into (it will be in two named ranges, but one is always contained within the other, eg in this example if the information the user entered was the name of a dog, the named range for it to be added to would be 'dog' which always sits inside 'mammal', if it were 'carp' it would always be in 'fish' etc).

    Basically I need to dim a txtbox/cbobox value as the named range, which is "dog" in the example below.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Variable for named range in combobox

    Try replacing:
    Please Login or Register  to view this content.
    With:
    Please Login or Register  to view this content.
    Does that do what you need?

    BSB

+ 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. Using Named range to populate a Combobox in userform
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2015, 09:57 PM
  2. Using named range to populate ComboBox
    By tanktata in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-29-2015, 04:39 PM
  3. [SOLVED] Connecting named range with ComboBox
    By drrazor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2014, 04:14 PM
  4. 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
  5. [SOLVED] Automatically answer Named Conflict Dialog with No and set Named range to variable
    By mlj61289 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2013, 08:32 PM
  6. [SOLVED] Combobox ListFillRange Using Formula Named Range
    By anteagles20 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2013, 07:40 AM
  7. [SOLVED] Populate combobox named range
    By zardof in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2012, 04:00 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