+ Reply to Thread
Results 1 to 1 of 1

ActiveX Combo Boxes - can I define the list to be displayed via formula?

  1. #1
    Registered User
    Join Date
    09-06-2012
    Location
    Hastings, NE
    MS-Off Ver
    Excel 2010
    Posts
    3

    ActiveX Combo Boxes - can I define the list to be displayed via formula?

    I am trying to use the data in worksheets ("Tax Table" & "US States") to fill in values using combo boxes on a separate worksheet ("Form" worksheet). Please Note: I have not made any of this data into a table/s.

    I have been using named ranges to select specific arrays and use them as the "listfillrange" component under properties at each combobox and formulas.

    Each row within each worksheet is comprised of the following columns:

    "Tax Table" worksheet

    1 = State
    2 = City
    3 = City Tax
    4 = State Tax
    5 = Total Tax

    "US States" worksheet

    1 = State (2 letter abbreviation)
    2 = State (spelled fully)

    At the "Forms" worksheet I am using activeX combobox1 to display a list of states, cell link = B2

    At the "Forms" worksheet I would like activeX combobox2 to utilize the value in cell B2 (selection made by combobox1) as a data reference to display a list of the cities associated with only the state represented in cell B2. Combobox2 cell link = B3

    Total tax - Cell C2 = index(match) formula

    With properties for of ActiveX controlbox2 displayed - at "listfillrange" I have tried to enter a index(match) formula but am not allowed to enter a formula or multiple arrays. Appears I cannot use a formula here?
    Attached Files Attached Files
    Last edited by pci1239; 09-07-2012 at 11:31 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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