Results 1 to 8 of 8

Excel 2007 : Combobox works with On sheet data validation list but not Off Sheet list

Threaded View

  1. #1
    Registered User
    Join Date
    07-01-2010
    Location
    Paris, VA
    MS-Off Ver
    Excel 2007
    Posts
    17

    Combobox works with On sheet data validation list but not Off Sheet list

    Attached is an example that I pulled from Contextures website (Grovier). There a re 3 sheets. The first sheet if the original file and all works as it should, In which the combobox attaches itself to the active cell containing data validation using one click. The lists for the data validation are contained on the same sheet.

    Sheet Two: is the same thing modified such that the data validation lists (moved to sheet List) are using the named Ranges of the lists offsheet. Most of the functionality of the combobox no longer works. Namely the font change , number of items the list dispplays on click, autocomplete dont work any more.

    any thoughts?
    Attached Files Attached Files

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