+ Reply to Thread
Results 1 to 5 of 5

Stuck with search funktion

Hybrid View

  1. 11-10-2011, 11:03 AM #1
    zekethewolf
    zekethewolf is offline
    Registered User
    Join Date
    10-25-2010
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    17

    Stuck with search funktion

    Hi
    Im trying to create 2 diffrent search funktion and im stuck.
    The first one is made to look into a datasheet and match 2 diffrent values from a userform and see if theres a match. If it finds a match a new userform pops up and ask if you want to replace the old values in the datasheet. But that means it have to get a fix on the adress from the match on the first userform, i tryed to solve it by creating 2 diffrent seraches, but i cant get them to work.

    Hope somebody can help me!

    I added my workbook to attachments
    Attached Files Attached Files
    Last edited by zekethewolf; 11-11-2011 at 05:03 AM.
    Reply With QuoteRegister To Reply
  2. 11-10-2011, 12:13 PM #2
    antoka05
    antoka05 is offline
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Stuck with search funktion

    See attached file, I modified some things and now Ihope it is fine.

    Regards,
    Antonio
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 11-10-2011, 02:06 PM #3
    zekethewolf
    zekethewolf is offline
    Registered User
    Join Date
    10-25-2010
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Stuck with search funktion

    Hi Antonio

    Tnx for the replay!

    Its still have problem with matching both criteria in the userform2 code. If there are 2 bookings with the same date and different company, it finds the first one and do replace the values, but the second one it only finds but cant replace. I'm not sure why, its similar to the problem i been having all along!

    Any suggestion?

    /Zeke
    Reply With QuoteRegister To Reply
  4. 11-11-2011, 04:08 AM #4
    antoka05
    antoka05 is offline
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Stuck with search funktion

    See attached file, I hope it's ok as you need.

    Regards,
    Antonio
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 11-11-2011, 05:01 AM #5
    zekethewolf
    zekethewolf is offline
    Registered User
    Join Date
    10-25-2010
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Stuck with search funktion

    Yeah that works great!
    Should have know to not loop it as i did, but sometimes you get stupid

    Tnx alot Antonio!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1