|
-
Jul 19th, 2006, 06:26 PM
#1
Thread Starter
New Member
[RESOLVED] Simple search form
Okay, I am new to this VBA thing so forgive me if I seem a little slow.
Basically what I would like to do is make a search form for a spreadsheet in excel. I have the sheet with all of the data and a basic form made. I just need some help with the actual coding.
Currently in the excel file there is 1 sheet with the data, 5 columns worth (EQ#, Spacer, DESC, PATH, LINK). I also have a form with a textbox, a search button, a reset button, and a listbox.
What I would like to happen is to enter a seach string (1-4 numbers or letters) into the textbox on the form, have it search the EQ# column on the sheet, and return any matching values in the listbox (the return value needs to include the EQ#, Spacer, and DESC).
I have further asperations for this form, but this should be enough to keep me thoroghly confused for quite some time.
Thanks for any help that you can give me.
Last edited by mavt14; Jul 19th, 2006 at 06:29 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|