+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 21 of 21

Matching values of String type

  1. #16
    Registered User
    Join Date
    01-05-2019
    Location
    singappre
    MS-Off Ver
    2016
    Posts
    8

    Re: Matching values of String type

    hi sintek,
    "Dim i As Long" does not work for me, i keep receiving Compile Error: Syntax Error on the "Private Sub ComboBox1_Change()" line.

    Please Login or Register  to view this content.

  2. #17
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    14,076

    Re: Matching values of String type

    If you don't even test my code, ignore my code.

  3. #18
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,515

    Re: Matching values of String type

    1. Scalability.

    If you have 1000 rows of data then you will have 1000 items in the combobox. So it will take ages to find the right line.
    My way is a lot faster.

    2. Understanding the Code.

    I have added notes:-

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 01-10-2019 at 02:12 PM.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  4. #19
    Registered User
    Join Date
    01-05-2019
    Location
    singappre
    MS-Off Ver
    2016
    Posts
    8

    Re: Matching values of String type

    Quote Originally Posted by jindon View Post
    If you don't even test my code, ignore my code.
    i really appreciate u taking the time to help fix my issue, but i can't test it if i dont understand, i have to understand the code as i need to explain it. no need to get all offended and become passive-aggressive
    Last edited by chrischris369; 01-12-2019 at 10:47 AM.

  5. #20
    Registered User
    Join Date
    01-05-2019
    Location
    singappre
    MS-Off Ver
    2016
    Posts
    8

    Re: Matching values of String type

    Quote Originally Posted by mehmetcik View Post
    1. Scalability.

    If you have 1000 rows of data then you will have 1000 items in the combobox. So it will take ages to find the right line.
    My way is a lot faster.

    2. Understanding the Code.

    I have added notes:-

    Please Login or Register  to view this content.
    Thank u so much for taking the time to explain your code. i will try to understand it hahaha.

  6. #21
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,515

    Re: Matching values of String type

    Feel free to come back to me at any time.

    That is the only way to learn.
    Attached Files Attached Files
    Last edited by mehmetcik; 01-12-2019 at 06:56 PM.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

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