Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I replace the path of the linked spreadsheet in a cell? | Excel Worksheet Functions | |||
How do I look up values from a range of values? | Excel Worksheet Functions | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Copying linked cell references. | Excel Worksheet Functions |