Results 1 to 9 of 9

Using the indirect function with combo boxes

Threaded View

  1. #4
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Using the indirect function with combo boxes

    You can't use INDIRECT with comboboxes. Whereas Data Validation List returns a string, which you can use further for INDIRECT. As you know, INDIRECT requires string for its argument. Combobox, instead, returns integer. You must link combo box with an any cell in the sheet, then you will have to use another formulas like INDEX, OFFSET, MATCH and many others to achieve you goal.
    Last edited by contaminated; 04-22-2011 at 04:24 PM.

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