drop down box

[ratu4110]

Hello all,

I have two general questions regarding drop down box:

1. I have a list of product under a title. I want to create drop down boxes in the same worksheet. How can I create drop down boxes in same worksheet and different worksheet with this list? And what if I want to delete this list later, what's the procedure to delete it?

2. I am working on a configurator which has four worksheets and they are kind of linked each other by excel programming using OFFSET, VLOOKUP,IF statement etc..

I had 33 old charts in second worksheet. The goal is to pick the right part no from each chart at a cell location beside each chart indicates Drawing part no. using mentioned excel programming language.
Now I got 33 new charts where my parameters got changed. Like previously, my part no was chosen from combination of A & B. Now that is C & D. And also the charts columns and rows number changed according to neeed. I was trying to write new program and save it. The program worked but my all drop down boxes moved from their original place and they shrink as well in less than quarter inch.

Nobody until today was able to give me the solution.

Would you please try for me.

Thanks.

[wayneg]

1. I have a list of product under a title. I want to create drop down boxes in the same worksheet. How can I create drop down boxes in same worksheet and different worksheet with this list? And what if I want to delete this list later, what's the procedure to delete it?

what you can do for that is to simply make a new colums and inport the list into it by saying..... ='sheet'1!a3..... etc

[ratu4110]

Hey,

Thanks but I am not clear about ur solution. Would you please make it clear by giving a simple example.

[JBeaucaire]

USE DATA VALIDATION and NAMED RANGES

1) Create a Named Range of your source list:

Select the range of cells be included in the list, then type a name for the list into the Name Box (just left of the formula bar).

http://screencast.com/t/JBkubPpk

2) Apply a Data Validation List using the named range as the source

Select the cells to have your new drop downs
Open the Data > Data Validation for those cells and apply settings of:

Allow: List
Source: =MyListOfNames

http://screencast.com/t/GKKSBs5MvQqT

Then you will have drop downs in those cells:

http://screencast.com/t/nvTJm8rJVe9g

[ratu4110]

Thanks JB. I actually mentioned wrong way. Its not drop down box but combo box. I know how to create it but problem is I tried to do something in programming in my excel sheet. And after I save it and reopen it, all combo boxes moved from their original pages and they got shrink. How can I fix this problem which is vital for me.

[ratu4110]

actually boxes move from their original locations!!