Results 1 to 7 of 7

Thread: [RESOLVED] Simple search form

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2006
    Posts
    6

    Resolved [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
  •  



Click Here to Expand Forum to Full Width