locked
regarding search in textbox and appear resualt by writting first word (auto complete) RRS feed

  • Question

  • good greeting my dears

    i want to search inside textbox and this textbox support (auto complete) option

    although the textbox related with one column inside sheet

    how can i made it

    thanks alot...........

    Monday, March 5, 2018 4:33 AM

Answers

  • Hi,

    I would like to confirm:

    (1) Where is the TextBox? in worksheet, or in UserForm?
       If it is in worksheet, is it an ActiveX control?

    (2) What do you mean by "this textbox support (auto complete) option?
      Please explain it more clearly. 

    (3) What do you mean by "the textbox related with one column inside sheet"?
      Please explain it more clearly. 

    I suppose it would be the best way that you provide/insert a schreenshot of your sheet as a sample.

    Regards,

    Ashidacchi >> http://hokusosha.com/


    • Edited by Ashidacchi Monday, March 5, 2018 5:20 AM
    • Marked as answer by TAREK SHARAF Monday, March 5, 2018 8:06 AM
    Monday, March 5, 2018 5:19 AM

All replies

  • Hi,

    I would like to confirm:

    (1) Where is the TextBox? in worksheet, or in UserForm?
       If it is in worksheet, is it an ActiveX control?

    (2) What do you mean by "this textbox support (auto complete) option?
      Please explain it more clearly. 

    (3) What do you mean by "the textbox related with one column inside sheet"?
      Please explain it more clearly. 

    I suppose it would be the best way that you provide/insert a schreenshot of your sheet as a sample.

    Regards,

    Ashidacchi >> http://hokusosha.com/


    • Edited by Ashidacchi Monday, March 5, 2018 5:20 AM
    • Marked as answer by TAREK SHARAF Monday, March 5, 2018 8:06 AM
    Monday, March 5, 2018 5:19 AM
  • DEAR 

    THE TEXT BOX INSIDE USERFORM

    AND I WANT WHEN START WRITE INSIDE TEXTBOX THE INFORMATION APPEAR UP TO MY ENTRY

    AND THIS TEXTBOX IMPORT IT'S CONTENT FROM SHEET RANGE

    LIKE 

    TEXTBOX1 = SHEET1.RANGE(B2)

    FOR EXAMPLE

    REGARDS.........

    Monday, March 5, 2018 8:24 AM
  • Hi,

    I ask you to write your post with upper-case and lower-case characters.
    All upper-case is not easy to read.

    Regards,

    Ashidacchi >> http://hokusosha.com/

    Monday, March 5, 2018 8:59 AM
  • The text box inside userform<o:p></o:p>

    And i want when start write inside textbox the information appear up to my entry<o:p></o:p>

    And this textbox import it's content from sheet range<o:p></o:p>

    Like <o:p></o:p>

    Textbox1 = sheet1.range(b2)<o:p></o:p>

    For example

    and give user wrong message if he write inside textbox somthing diffrent

    Regards.........<o:p></o:p>


    Monday, March 5, 2018 9:09 AM
  • Hi,

    Please provide your code as for the question.

    Regards,

    Ashidacchi >> http://hokusosha.com/

    Monday, March 5, 2018 11:55 AM
  • Private Sub TEXTBOX6_change()
    lr = WorksheetFunction.CountIf(Range("n2:n1000"), Val(TextBox6.Value))
    If TextBox6.Value <> "" And lr = 1 Then
    TextBox6.Value = worksheetfuction.VLookup(Val(TextBox6.Value), Range("n2:n1000"), 0, 0)
    Else
    MsgBox ""
    TextBox6.Value = ""
    End If


    Me.TextBox6.BackColor = vbWhite




    End Sub
    Monday, March 5, 2018 12:01 PM
  • Hi,

    Thank you for providing your code. And sorry for my another question.

    What kind of text is typed in TEXTBOX6?
    I suppose it is a single word, instead of sentence or paragraph with several words.
    Please provide a few examples in TEXTBOX6 and column N.

    Regards,


    Ashidacchi >> http://hokusosha.com/

    • Edited by Ashidacchi Monday, March 5, 2018 11:47 PM
    Monday, March 5, 2018 11:46 PM
  • dear

    good greeting

    the kind of text

    just numbers

    no alphabitical

    no sympols

    thanks.......

    Tuesday, March 6, 2018 4:53 AM