| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Box
I've never worked with List Boxes and I think that I may need to learn now.
I'd like to create a list box with values to search for in column B: If Apples is selected then search in column B for: Apples move one column over: ActiveCell.Offset(0, 1).Range("A1").Select Perform a "get pivot data" from another workbook on that cell - there is an If statement in here in case the value isn't found Then search for the next instance of Apples and do the same thing Any suggestions would be VERY MUCH appreciated!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing List A to List B and add what's missing from List B | Excel Discussion (Misc queries) | |||
| create new list from list A, but with exclusions from a list B | Excel Worksheet Functions | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Hybrid Mode
