LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
fLy fLy is offline
external usenet poster
 
Posts: 4
Default I want to choose a name then other details will appear on othe

I already did this before but the combo box doesn't do the same thing it
does for the sample, no autocomplete.. etc. I'm thinking that the VBA code
may need a little tweaking.

"Gord Dibben" wrote:

Name the list under InsertNameDefine.

Call it MyList.

Then in DV source dialog enter =MyList


Gord Dibben MS Excel MVP

On Fri, 5 Jan 2007 18:51:01 -0800, fLy wrote:

This sample:
http://www.contextures.com/xlDataVal10.html
used a list located in the same worksheet. I want to apply this on a list
that is located on another worksheet. What changes should I make?



 
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
Identify the duplicate and delete with details in excel mat Excel Discussion (Misc queries) 0 November 15th 06 09:03 PM
Pivot Tables - Showing Details for some fields, but just summaries for others [email protected] Excel Worksheet Functions 0 November 13th 06 09:11 PM
Pivot table details anandmr65 Excel Discussion (Misc queries) 1 May 9th 06 02:05 PM
Generating numbers & submitting details from one sheet to another Meenakshi Sood Excel Worksheet Functions 0 February 9th 06 06:57 PM
details of month srinivasan Excel Worksheet Functions 9 July 15th 05 08:42 AM


All times are GMT +1. The time now is 11:32 PM.

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

About Us

"It's about Microsoft Excel"