Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropw down user form in Excel
Maybe you can use Data|Validation as the dropdown.
Say the cell that will contain the part number is in A2 Then in B2, you could use: =if(a2="","",vlookup(a2,sheet2!a:c,2,false) in C2: =if(a2="","",vlookup(a2,sheet2!a:c,3,false) See Debra Dalgleish's site for some nice notes: http://contextures.com/xlDataVal01.html and http://contextures.com/xlFunctions02.html K E Senthilkumar wrote: Hi, I have a list of 700 items on sheet2. The order of the column is like partno,description, priceper unit. In sheet1, i want a drop down list showing the items from sheet2. When i choose the item, i want all the 3 columns to appear on my sheet1. So far i used user forms to create a drop down list(shows 3 columns), can choose, but i get only 1 column value in the cell. I want all the 3 cells to appear on sheet1. How can i achieve this. thanks for the replies. Senthilkumar -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel User Form | Excel Worksheet Functions | |||
Dynamic user form - VBA and Excel | Excel Programming | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
hyperlinks in a dropw down list | Excel Discussion (Misc queries) |