+ Reply to Thread
Results 1 to 4 of 4

Search Engine VBA

  1. #1
    Registered User
    Join Date
    02-08-2023
    Location
    Jakarta, Indonesia
    MS-Off Ver
    365
    Posts
    8

    Talking Search Engine VBA

    Hello Guys, So I have a search Engine that can search data by keyword
    but there is a problem..
    Screenshot 2023-05-16 172744.png
    for example, if I want to search surname "ace bisa" and I write "Ace" in kata kunci textbox, the result will show like this
    Screenshot 2023-05-16 172808.png


    but when i write "bisa" the result won't show, and there is notifier pop out "the data isn't available"
    Screenshot 2023-05-16 172833.png
    can you guys help me to fix this?
    i want to make that it can search surname for example not only with their first word, but also it can search their middle or any word that contain when we typing any letter or word in kata kunci text box
    here is the file and code, it's been 2 weeks and i still cant solve it

    Thanks in advance!!!
    here is the file and code
    Last edited by robyrubyjane; 05-17-2023 at 04:50 AM.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Search Engine VBA

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    10-02-2012
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    252

    Re: Search Engine VBA

    Just following up from sinteks reply, you need to use wildcards (*), as you're searching for part of a value, not the start of the value. You can either do that progmatically as sintek has shown, or manually when searching by putting in the wildcards, so instead of searching for "bisa", search for "*bisa*"

  4. #4
    Registered User
    Join Date
    02-08-2023
    Location
    Jakarta, Indonesia
    MS-Off Ver
    365
    Posts
    8

    Re: Search Engine VBA

    oh my god, it works!!! Thank you very muchhhhhh

+ 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 Searching a Search Engine Not Recognizing Search Term
    By mattman123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2017, 02:03 PM
  2. Search Engine Tips to search through multiple URLs
    By IonutC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2016, 06:56 AM
  3. Search Engine VBA
    By aeschylus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2015, 11:14 AM
  4. Search Engine
    By kmcclintic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2014, 07:56 AM
  5. Search engine
    By Ryan_Bernal in forum Excel General
    Replies: 8
    Last Post: 12-24-2012, 03:14 AM
  6. Search engine
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-11-2009, 01:16 PM
  7. Developing Search Engine to search several Excel sheets
    By cruiser102 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2009, 09:30 AM

Tags for this Thread

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