| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 107572 | 2010-02-22 09:04:00 | Excel/VBA - select from list | Greven (91) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 860595 | 2010-02-22 09:04:00 | 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. |
Greven (91) | ||
| 860596 | 2010-02-22 22:36:00 | This may help - extracted from ExcelForum (www.excelforum.com). You can do this with data validation and programming. There's a sample file here: www.contextures.com 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 |
odyssey (4613) | ||
| 860597 | 2010-02-23 10:02:00 | 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. |
Greven (91) | ||
| 1 | |||||