Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Identify the duplicate and delete with details in excel | Excel Discussion (Misc queries) | |||
Pivot Tables - Showing Details for some fields, but just summaries for others | Excel Worksheet Functions | |||
Pivot table details | Excel Discussion (Misc queries) | |||
Generating numbers & submitting details from one sheet to another | Excel Worksheet Functions | |||
details of month | Excel Worksheet Functions |