Excel question

This is a discussion on Excel question within the Tech Board forums, part of the Community Boards category; I creating an Excel Spreadsheet with multiple pages for work to aid in dispatching drivers. Sheet 1 is the main ...

  1. #1
    Darkness Prevails Dark_Phoenix's Avatar
    Join Date
    Oct 2006
    Location
    Houston, Texas
    Posts
    174

    Excel question

    I creating an Excel Spreadsheet with multiple pages for work to aid in dispatching drivers. Sheet 1 is the main age with all the good stuff, while Sheet 2 contains a very long list of customer names and addresses. Sheet one uses a data validation list to select customers from the list contained on sheet 2. The drop down that the validation list offers make for easy selection from the list, but since the list is so long I would like to take it to the next level by incorporating an autocomplete feature on the drop down. I know that this is not possible in Excel unless the master list is directly above the cell with the validation list. Due to other factors I cann't do this, the master list has to be on a seperate sheet. I've discovered that by using some VBA programming I can fool Excel into having an autocomplete, like what is here http://www.contextures.com/xlDataVal10.html . This works great but the list still has to be on the same sheet.

    My question is how can I get autocomplete features on a data validation list where the master list is on a different sheet?
    Using Code::Blocks and Windows XP

    In every hero, there COULD be a villain!

  2. #2
    and the Hat of Guessing tabstop's Avatar
    Join Date
    Nov 2007
    Posts
    14,185
    Looking at the demo site you linked, the very next demo (#11) appears to do what you want. (I don't have Excel on this machine right here, so I can't try it out myself.)

  3. #3
    Darkness Prevails Dark_Phoenix's Avatar
    Join Date
    Oct 2006
    Location
    Houston, Texas
    Posts
    174
    OMG! I did not even look at that! Looking at the VBA code listed, I think I see what I was missing now.

    I guess I just needed a fresh set of eyes... Thanx!
    Using Code::Blocks and Windows XP

    In every hero, there COULD be a villain!

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. another do while question
    By kbpsu in forum C++ Programming
    Replies: 3
    Last Post: 03-23-2009, 01:14 PM
  2. C++ Builder and Excel files
    By mfdemi in forum Windows Programming
    Replies: 3
    Last Post: 09-24-2004, 02:51 AM
  3. Reading Excel Files?
    By Daniel in forum C++ Programming
    Replies: 2
    Last Post: 08-13-2003, 07:03 PM
  4. Question...
    By TechWins in forum A Brief History of Cprogramming.com
    Replies: 16
    Last Post: 07-28-2003, 10:47 PM
  5. opengl DC question
    By SAMSAM in forum Game Programming
    Replies: 6
    Last Post: 02-26-2003, 09:22 PM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21