+ Reply to Thread
Results 1 to 7 of 7

finding the members in excel Macro's

  1. #1
    Registered User
    Join Date
    01-20-2014
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    4

    finding the members in excel Macro's

    In excel, whenever we type a member in Sheet 1, the member should be searched in table or list of members dynamically in Sheet2. If the member is not found in list of members or table, the user should be notified with the error message like “Entered member is not present in the database”.

    Could someone provide the steps to get this requirement

    Thanks!
    srv

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: finding the members in excel Macro's

    Hi VSR,

    Use the Worksheet_Change event in Sheet 1 to Launch the Finder for Sheet 2.
    Then, if Finder was unsuccessful, generate message box with notification.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    01-20-2014
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: finding the members in excel Macro's

    Thanks for your valuable inputs. As I am new to this Macro environment, Could you please provide in details steps to implement my requirement.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,004

    Re: finding the members in excel Macro's

    Hi and welcome to the forum

    This could also be done with a simple vlookup(), wrapped in an IF() statement to return the “Entered member is not present in the database” message if not found.

    Another option would be to use data validation on that cell (based on the names list) to only allow existing names to be entered
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    01-20-2014
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: finding the members in excel Macro's

    Thanks for your inputs!

    Requesting you please provide clear steps to implement my requirement.

    Thanks!!

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: finding the members in excel Macro's

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  7. #7
    Registered User
    Join Date
    01-20-2014
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: finding the members in excel Macro's

    Hi,

    Please find my requirement in below wit images.

    Excel File Name: Book1
    Two Sheets: Sheet1 & Sheet2

    1. In Sheet2, We are having data of whole sheet2(Here I am showing with sample )
    11.jpg

    2. In Sheet1, There is Text option, In That We have to enter our Text(Here DOG)
    That Entered text have to search in Sheet2 and If Text is not existing Then it should be pop up with message as "Member existed in Database"
    22.JPG

    3. In Sheet1, There is Text option, In That We have to enter our Text(Here GOLD)
    That Entered text have to search in Sheet2 and if text not existing in sheet2, Then it should be pop up with message as "Entered member is not present in the database"

    33.jpg


    Kindly check my screenshots and provide the clear steps to proceed

+ 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. Hi Excel Forum Members!!
    By kajacksz in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-15-2013, 12:01 PM
  2. Replies: 7
    Last Post: 03-29-2013, 04:42 PM
  3. Hello Excel Forum Members
    By micharmaz in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-18-2012, 04:30 AM
  4. Greetings to all Excel forum members
    By obil0001 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-04-2012, 03:37 PM

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