Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list
Hi
I am new to VBA. I want to create a dropdown list in Sheet1!A1 with data from Sheet2!A1:A400. I have already filtered the data in Sheet2!. Is there anyone who knows a short explanation or maybe just know a link for VBA-beginners? -- Therese |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list
Therese
You don't need VBA for that. Simply name the range in Sheet2 and use the name in the Data Validation in Sheet1. Do this: Select Sheet2. Click in the name box (right above the "A" of Column A) and type "A1:A400" without the quotes. Hit Enter Now A1:A400 is selected. Click on Insert - Name - Define. Type in the range name you wish, any name, say MyRange. Click OK. Now go back to Sheet1 and click on the cell in which you want the Data Validation. Click on Data - Validation. In the "Allow:" box, click on the down arrow and select List. In the "Source:" box, type "MyRange" without the quotes. Click OK. Done HTH Otto "Therese" wrote in message ... Hi I am new to VBA. I want to create a dropdown list in Sheet1!A1 with data from Sheet2!A1:A400. I have already filtered the data in Sheet2!. Is there anyone who knows a short explanation or maybe just know a link for VBA-beginners? -- Therese |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list
Hi Otto
Thanks a lot. There is just one little problem...when the button show, the only word I can choos is "Produkt" wich is what I called the list instead of myrange. But thanks for explaning. "Otto Moehrbach" skrev: Therese You don't need VBA for that. Simply name the range in Sheet2 and use the name in the Data Validation in Sheet1. Do this: Select Sheet2. Click in the name box (right above the "A" of Column A) and type "A1:A400" without the quotes. Hit Enter Now A1:A400 is selected. Click on Insert - Name - Define. Type in the range name you wish, any name, say MyRange. Click OK. Now go back to Sheet1 and click on the cell in which you want the Data Validation. Click on Data - Validation. In the "Allow:" box, click on the down arrow and select List. In the "Source:" box, type "MyRange" without the quotes. Click OK. Done HTH Otto "Therese" wrote in message ... Hi I am new to VBA. I want to create a dropdown list in Sheet1!A1 with data from Sheet2!A1:A400. I have already filtered the data in Sheet2!. Is there anyone who knows a short explanation or maybe just know a link for VBA-beginners? -- Therese |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list
Hey thanks. But when I have done it, the only word I can choose is "produkt"
which is what I called the list. What do you think I did wrong? I've done all the rest. "Otto Moehrbach" skrev: Therese You don't need VBA for that. Simply name the range in Sheet2 and use the name in the Data Validation in Sheet1. Do this: Select Sheet2. Click in the name box (right above the "A" of Column A) and type "A1:A400" without the quotes. Hit Enter Now A1:A400 is selected. Click on Insert - Name - Define. Type in the range name you wish, any name, say MyRange. Click OK. Now go back to Sheet1 and click on the cell in which you want the Data Validation. Click on Data - Validation. In the "Allow:" box, click on the down arrow and select List. In the "Source:" box, type "MyRange" without the quotes. Click OK. Done HTH Otto "Therese" wrote in message ... Hi I am new to VBA. I want to create a dropdown list in Sheet1!A1 with data from Sheet2!A1:A400. I have already filtered the data in Sheet2!. Is there anyone who knows a short explanation or maybe just know a link for VBA-beginners? -- Therese |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list
?B?IlQi?= wrote
Hey thanks. But when I have done it, the only word I can choose is "produkt" which is what I called the list. What do you think I did wrong? I've done all the rest. Otto forgot to put an = in front of his Allow List example. In your case, put =produkt there. -- David |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list
Wow...it worked. Excellent, I'm truly impressed!
Thanks and Merry X-mas :-) -- Therese "David" skrev: ?B?IlQi?= wrote Hey thanks. But when I have done it, the only word I can choose is "produkt" which is what I called the list. What do you think I did wrong? I've done all the rest. Otto forgot to put an = in front of his Allow List example. In your case, put =produkt there. -- David |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list
David
You got me on that one. Thanks for correcting that. Otto "David" wrote in message ... ?B?IlQi?= wrote Hey thanks. But when I have done it, the only word I can choose is "produkt" which is what I called the list. What do you think I did wrong? I've done all the rest. Otto forgot to put an = in front of his Allow List example. In your case, put =produkt there. -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
HELP! Nesting IF Statements/Dependent Dropdown List | Excel Worksheet Functions | |||
Jump to Sheet Dropdown List | Excel Worksheet Functions | |||
how to create multiple hyperlinks within a dropdown list | Excel Discussion (Misc queries) | |||
HOW TO GET DROPDOWN LIST TO LINK TO OTHER CELLS? | Excel Discussion (Misc queries) |