Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search question
Hi ! I desperately would like to ask one of your help. I had never touched VBA, and I have to create a small thing in excel, which i am not able to do since 2 days, and I know it is stupidly simple. In detail : - I have a workbook with 2 worksheet. One is where 2 columns of datas exist. The other one where I placed a ListBox, and a Button. - Worksheet name with datas called : "Data Stored" - Worksheet where my ListBox and Button is : "Search" - In "Data Stored" sheet there are hundreds of first names in column A, and hundreds of last names in column B. - I have one cell in "Search" sheet, where I enter the text I wanna search for. This cell is D11. What I have to do : - When I push the button (placed on "Search" sheet), a VBA macro should look into the cell D11, and search all A and B columns in "Data Stored" sheet for the text in D11. If in any of the A or B column cell (in "Data Stored") the text is found even just a part of a cell text, add it to the ListBox (placed on "Search" sheet). - Thats all. Could somebody drop me a helping hand in this with a concrete few lines of code PLEASE ? Many many many thank you for your time and help in advance, Moore -- coolice ------------------------------------------------------------------------ coolice's Profile: http://www.excelforum.com/member.php...o&userid=27526 View this thread: http://www.excelforum.com/showthread...hreadid=470475 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to search my past question ? | Excel Discussion (Misc queries) | |||
How to search my past question ? | Excel Worksheet Functions | |||
Search Function Question | Excel Worksheet Functions | |||
search and replace question | Excel Programming | |||
search question | Excel Programming |