If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell linked to a range of cell values in different sheet
I want to setup a workbook that for cell 1 in sheet 1, it would be shown as
an edit combox-like cell, and its value would be associated with an range values defined (as a defined name) in sheet 2. So when I click on cell 1, a drop-down list would show all the values in that defined name. I would then be able to select one of the values. I saw one sample workbook has such an edit combox-like cell but cannot figure out how it was done. I checked into Visual Basic Editor and didn't find any macro codes defined anywhere in that workbook. Any suggestion? |
#2
|
|||
|
|||
Maybe it was Data|Validation.
Debra Dalgleish has tons of tips and hints at: http://www.contextures.com/xlDataVal01.html szeng wrote: I want to setup a workbook that for cell 1 in sheet 1, it would be shown as an edit combox-like cell, and its value would be associated with an range values defined (as a defined name) in sheet 2. So when I click on cell 1, a drop-down list would show all the values in that defined name. I would then be able to select one of the values. I saw one sample workbook has such an edit combox-like cell but cannot figure out how it was done. I checked into Visual Basic Editor and didn't find any macro codes defined anywhere in that workbook. Any suggestion? -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Possible Lookup Table | Karen | Worksheet Functions | 5 | June 8th, 2005 09:43 PM |
Link - deactivate being sent to source when click on linked cell? | Dave Peterson | Worksheet Functions | 0 | January 11th, 2005 02:11 AM |
Range names selected from within a cell | Alan Hines | Worksheet Functions | 2 | July 21st, 2004 02:23 PM |
Formula cell references when sorting values in another worksheet | Frank Kabel | Worksheet Functions | 0 | March 30th, 2004 11:27 AM |
emailing cell range | alldreams | Worksheet Functions | 2 | January 29th, 2004 03:28 PM |