+ Reply to Thread
Results 1 to 8 of 8

Seach a word and get all related details in message box from master file

  1. #1
    Registered User
    Join Date
    09-23-2015
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Seach a word and get all related details in message box from master file

    Hi All,

    Could anyone please help me on below query in VBA?

    I have master file where we have lots of data. I want to make a box through user form in which I just put a word and get all the related details in message box. For example. I have attached a Data file in which we have four columns A =Company ID, B=Property ID, C=Location usage, D=Term status.

    I want once I open excel and run the macro then one box appear Company ID filed where I can find any of the given id in sheet and get a message box with all other details like PROPERT ID, LOCATION USAGE AND TERM STATUS in message box.

    please suggest the code as I am not a regular user of VBA but I am trying to learn it.

    Thanks
    Ankit Jain
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Seach a word and get all related details in message box from master file

    No user form found in your attachment, so input box.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-23-2015
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Seach a word and get all related details in message box from master file

    Thanks Jindon.
    Your code is working but result comes in Columns like I searched G2192 and found result in below manner

    G2005 SYDFT3 Freight Holdover

    Is it possible that we can get result in rows with bold highlighted head names.

    Tenure Id - G2005
    Property ID - SYDFT3
    Location Usage - Freight
    Terms Status - Holdover

    Thanks Again,
    Ankit Jain

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Seach a word and get all related details in message box from master file

    Change to
    Please Login or Register  to view this content.
    Last edited by jindon; 06-06-2017 at 05:51 AM.

  5. #5
    Registered User
    Join Date
    09-23-2015
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Seach a word and get all related details in message box from master file

    Hi Jindon,

    its working great. one more thing I am trying. I have added another tab name sheet 1 and put a button over there. I want that once I clicked on button then macro run on the same tab means Sheet 1 and get the result on same sheet, it should not go on AP Holdover sheet to.

    I am trying my best but not getting the result it always take me on AP holdover tab. Please help me with code to resolve it.

    I am adding
    Please Login or Register  to view this content.
    in code after
    Please Login or Register  to view this content.
    Thanks,
    Ankit Jain
    Last edited by AnkitJain; 06-06-2017 at 06:27 AM.

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Seach a word and get all related details in message box from master file

    Code has been edited before your last post.

    It should work when you are in any other worksheet.

  7. #7
    Registered User
    Join Date
    09-23-2015
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Seach a word and get all related details in message box from master file

    Hi Jindon,

    Thanks for your support. its really working as I want, its such a great platform to learn as experienced people are associated with this forum.

    one more thing I wanted to do but don't know if it is feasible. is it possible to convert this file in .EXE file so I can save it on my desktop and run by double clicking and work as doing now?

    Also I have added Dates in next column and run the macro. In Result, only numbers are showing instead of date. is there any changes required in code or any format issue?

    Ankit Jain
    Last edited by AnkitJain; 06-07-2017 at 05:27 AM.

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Seach a word and get all related details in message box from master file

    Google for something like "Excel To Exe converter".

+ 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. Automatically post row details from master sheet to other sheets
    By xiedwo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-03-2014, 06:32 AM
  2. Replies: 0
    Last Post: 03-04-2013, 03:40 AM
  3. [SOLVED] Macro to Seach word and color the row till G coloum.
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-29-2013, 02:56 PM
  4. Seach in folder and copy data from file based on sheet names in master workbook
    By Hassų in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-06-2012, 09:25 AM
  5. Search,update, and add details on master file
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-03-2012, 10:20 PM
  6. [SOLVED] Master details in 2 dropdownbox
    By Man Utd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2005, 01:05 AM
  7. Replies: 1
    Last Post: 02-07-2005, 05:06 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