+ Reply to Thread
Results 1 to 4 of 4

Search Through Database And Display Results In Userform without showing database

  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2007
    Posts
    2

    Search Through Database And Display Results In Userform without showing database

    Hi,

    Thanks for an example work on http://excel.bigresource.com/Search-...-Zj72l16t.html
    But there is a problem for me...in this work how I can write the code to show direct userform without using "search" commondbutton in sheet1, in the code of "search" commondbutton on userform there is no word for make search in sheet1 database. The code is below. Thank you for help

    Please Login or Register  to view this content.
    Last edited by Cutter; 08-03-2012 at 07:18 PM. Reason: Added code tags

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Search Through Database And Display Results In Userform without showing database

    @ nirvanarapeme

    Welcome to the forum.

    Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
    Thanks.

  3. #3
    Registered User
    Join Date
    08-03-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Search Through Database And Display Results In Userform without showing database

    Ohh, Rule #3 !!!! is a great idea for my code. So why I couldn't think this....Thanks Mr. Moderator...

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Search Through Database And Display Results In Userform without showing database

    So why I couldn't think this
    Because you didn't bother to read the rules.

    Your're welcome.

  5. #5
    Registered User
    Join Date
    08-03-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Search Through Database And Display Results In Userform without showing database

    (Sorry for this, I have just seen QUOTE button)

    İn brief, What code I must add to SEARCH commondbutton on the userform for saying " make this search for data in sheet1" ....because ı want to make all things for search on userform so without opening sheet1. Thanks
    Attachment 172307
    Last edited by nirvanarapeme; 08-04-2012 at 07:06 PM. Reason: For example work

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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