+ Reply to Thread
Results 1 to 2 of 2

How to create useform in excel VBA to search and display data on same form?

Hybrid View

  1. #1
    Registered User
    Join Date
    07-25-2013
    Location
    bhutan
    MS-Off Ver
    Excel 2007 $ 2010
    Posts
    12

    Angry How to create useform in excel VBA to search and display data on same form?

    HI,
    Anybody could help me on this?

    How to create useform in excel VBA to search and display data on same form?

    Features:
    Search the data using ID and D.O.B
    and it automatically displays other related information.

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,410

    Re: How to create useform in excel VBA to search and display data on same form?

    The attached file is one approach that may help if you are considering using a UserForm/VBA.
    It can be readily adapted as I have not locked the code, feel free to experiment.
    To enter new member press 'CLEAR' first, to edit existing select from 'listbox'.

    Torachan.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Useform search and copy data
    By amador in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2014, 11:56 AM
  2. Replies: 4
    Last Post: 12-28-2012, 03:11 AM
  3. Create Search form to filter data on another tab
    By bigroo1958 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2012, 05:35 PM
  4. Create a search engine in excel form
    By yingchai in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-17-2012, 09:01 AM
  5. Create a Excel Search Form that populates fields
    By RevJeff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2012, 09:51 AM
  6. [SOLVED] Excel: How to create a form to search for rows in another sheet?
    By Pieter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2006, 11:15 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