Results 1 to 3 of 3
  1. #1
    Senior Member Greven's Avatar
    Join Date
    Jun 2005
    Location
    Invercargill
    Posts
    3,740

    Default Excel/VBA - select from list

    My googling skills are failing me tonight. Does anyone know how to pop up a list of values (several columns) populated from another excel worksheet & insert a selected value into the currently selected cell?

    I decided to try recreate an excel 4 workbook in excel 2007 but have come unstuck. Even something like the dropdown boxes produced by data validation would work if it can show more than one column.

    Excel 2007 is supposed to be able to open old workbooks, but this one crashes excel every time. My client wants to ditch excel 4 & I thought it sounded like an interesting challenge.
    Intel Core i5-3470 CPU
    8GB DDR3 RAM
    1TB HDD
    AMD Radeon HD 6870 graphics card
    Enermax Tomahawk II 500W PSU
    Antec 300 case
    Win7 Pro (Action Pack :D)

    surprisingly quick even without an SSD

  2. #2

    Default Re: Excel/VBA - select from list

    This may help - extracted from ExcelForum.

    You can do this with data validation and programming. There's a sample
    file here:

    http://www.contextures.com/excelfiles.html

    Under Data Validation, look for 'DV0005 - Data Validation "Columns"'
    I took a quick look at the example workbook and although its for Excel 2000, it might suit what you are after.

    Cheers
    Dave

  3. #3
    Senior Member Greven's Avatar
    Join Date
    Jun 2005
    Location
    Invercargill
    Posts
    3,740

    Default Re: Excel/VBA - select from list

    That is exactly what I was after, but I found a cheat solution that I think might actually work better.

    I set it up to switch to the details worksheet when you double-click in the item-id column then you double-click on the item you want to add & it inserts it in the cell you originally double-clicked in. It was surprisingly simple to do once I thought of it.
    Intel Core i5-3470 CPU
    8GB DDR3 RAM
    1TB HDD
    AMD Radeon HD 6870 graphics card
    Enermax Tomahawk II 500W PSU
    Antec 300 case
    Win7 Pro (Action Pack :D)

    surprisingly quick even without an SSD