Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms/Macro Search
Hello,
I have a large spreadsheet with lots of columns. I have designed a UserForm to Help me select information to look at. I have categorized the items and can fill list & text boxes with "stage one" data. There are no two entries the same. What I want to do is push a button and populate some list boxes with "stage two" data. I think that this involves a search in the first column to find the item and then some method to bring in the data from the same row but several columns to the right. ITEM COL2 COL3 COL4 COL5 INFO1 INFO2 Seach for a specific item then fill box 1 and 2 with INFO1 and INFO2 respectively. I have spent 5hours today trying to do this and failed miserably. Can anyone help??? Thanks James |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search Macro | Excel Worksheet Functions | |||
Macro for Search | Excel Discussion (Misc queries) | |||
Search Macro | Excel Discussion (Misc queries) | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming |