Cell linked to a range of cell values in different sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sync same cell value in multiple places 2
#VALUE! when using defined name 3
Code to format cells on several worksheets 2
Excel VBA 1
Paste Values in linked Cells Only 4
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Cell Reference on a different sheet 3
Copy Sheet to new Sheet and clear cells on original sheets 7

Back
Top