Results 1 to 4 of 4

Search the value in the sheet using textbox and comman button

Threaded View

  1. #1
    Registered User
    Join Date
    06-15-2014
    Posts
    18

    Search the value in the sheet using textbox and comman button

    Hello everyone! Can you help me or give me advice about this.
    I have two textboxes the first textbox named Textbox1 and the second textbox named textbox2
    the first text box is used to search the items in F column and the second textbox is used to search the items in H columns.
    Firsttextbox is the corporate code and the second textbox is the corporate name

    so the specifications are
    1.If the textboxes has inputted details that corresponding corp code or corp name will appear. for example I enter the corpname if I click the search button the corp name will appear and the corresponding corp code in the textboxes and also in the cells d10 and f10.
    2.if I click the search button without the inputted details all the data in column F and H will appear in columns D and F

    I am using excel2007
    I hope you could help me. Advices or comments will be highly appreciated. I also attached a sample file for your guidance and help. Thanks alot
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. search next value with textbox in other sheet
    By danusko in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-20-2013, 05:22 AM
  2. Search a value of a textbox on another sheet and copy rows to first sheet
    By promoboy2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-01-2010, 03:05 PM
  3. Userform Search Textbox/button code amalgamation
    By AGrace in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2010, 09:49 AM
  4. [SOLVED] Comman Button to Save Worksheet as Workbook
    By tmstreet in forum Excel General
    Replies: 2
    Last Post: 07-17-2006, 12:50 PM
  5. Auto filter through the Comman Button
    By irsath in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2006, 08:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1