Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 8th 05, 10:38 PM
szeng
 
Posts: n/a
Default 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   Report Post  
Old August 9th 05, 02:41 AM
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I replace the path of the linked spreadsheet in a cell? Norm Excel Worksheet Functions 2 July 30th 05 06:26 AM
How do I look up values from a range of values? Chang Excel Worksheet Functions 2 May 11th 05 07:06 PM
Look for change next blank cell in Range Nigel Bennett Excel Worksheet Functions 1 March 13th 05 09:45 PM
how do you prevent data from changing values when sorting linked . Cassie Excel Discussion (Misc queries) 0 March 4th 05 10:45 AM
Copying linked cell references. Shams Excel Worksheet Functions 0 February 3rd 05 01:53 PM


All times are GMT +1. The time now is 08:30 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017