+ Reply to Thread
Results 1 to 1 of 1

Indirect function with ActiveX Combobox

  1. #1
    Registered User
    Join Date
    08-05-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Indirect function with ActiveX Combobox

    Dear Forum Folk,

    I have below a VBA script thanks to Tigeravatar & Dagindi, that works fantastic for ActiveX Combo Box to mimic the INdirect function in Data Validation. For generating dependant lists.

    Private Sub ComboBox1_Change()

    Me.ComboBox2.Clear
    Dim ListCell As Range
    For Each ListCell In Range(Me.ComboBox1.List(Me.ComboBox1.ListIndex))
    Me.ComboBox2.AddItem (ListCell.Value)
    Next ListCell

    End Sub


    However, It only works if the named ranges exist on the same worksheet. Does anyone know how to make the script work for named ranges on other worksheets?
    Thankyou all in advance. The attached file shows the sample from Tigeravatar & Dagindi.
    Attached Files Attached Files

+ 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. Indirect with ActiveX Combobox
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-06-2013, 04:25 AM
  2. ActiveX ComboBox
    By hqradio in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-27-2011, 01:21 PM
  3. Indirect with ActiveX Combobox (Revisit)
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2011, 01:39 PM
  4. Populate a activeX combobox from a selection of another combobox
    By ptramel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2009, 06:50 PM
  5. ActiveX ComboBox: Almost there!!!
    By akexcel in forum Excel General
    Replies: 2
    Last Post: 10-23-2006, 01:09 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