+ Reply to Thread
Results 1 to 16 of 16

ListBox Double Click not Adding to another TextBox

  1. #1
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    ListBox Double Click not Adding to another TextBox

    Hello all,

    I need help why this code is working for the first textbox only not working to add value another textbox?
    How to code to remove in textbox 1 to 1 x 1

    Thanks for the Help.

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: ListBox Double Click not Adding to another TextBox

    Don't post the workbook/Code that we can not even test.

    https://www.excelforum.com/excel-pro...-list-box.html

  3. #3
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    Re: ListBox Double Click not Adding to another TextBox

    I'm sorry again jindon . im thinking that code works in a another workbook in a same way.


    Sorry again i can't do this again.
    Last edited by Chandria; 10-19-2017 at 08:36 PM. Reason: a

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: ListBox Double Click not Adding to another TextBox

    If it lists in the ListBox, add one line at the top of the module of ListSearch form.
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    Re: ListBox Double Click not Adding to another TextBox

    jindon nothing change also top textbox change value not add to another textbox

  6. #6
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    Re: ListBox Double Click not Adding to another TextBox

    jindon i add the code to the declaration and its okay working
    Please Login or Register  to view this content.
    my problem when i search again the value start again in number 1 textbox
    how to avoid change the first textbox ?

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: ListBox Double Click not Adding to another TextBox

    Then
    1) Delete that added line from ListSearch form code module.

    2) To a Standard module, add one if you don't have any. [Insert] - [Module]
    Add one line
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    Re: ListBox Double Click not Adding to another TextBox

    @ jindon My problim is first search the value is add textbox but if i search again the first textbox replace to another? how to change to add only not to replace the textbox 1 if i search again?


    -Thanks

  9. #9
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: ListBox Double Click not Adding to another TextBox

    That should do and upload a workbook without protected sheet and the data that is working, then I will show you how.
    Otherwise just wasting time.

  10. #10
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    Re: ListBox Double Click not Adding to another TextBox

    Okay jindon also available on search 1, 5, 10
    Attached Files Attached Files
    Last edited by Chandria; 10-20-2017 at 02:50 AM.

  11. #11
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    Re: ListBox Double Click not Adding to another TextBox

    @jindon i want to ask if you have solution for my problem to finish my project.

    thanks,

  12. #12
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: ListBox Double Click not Adding to another TextBox

    Quote Originally Posted by jindon View Post
    Then
    1) Delete that added line from ListSearch form code module.

    2) To a Standard module, add one if you don't have any. [Insert] - [Module]
    Add one line
    Please Login or Register  to view this content.
    3) Change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Attached Files Attached Files

  13. #13
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    Re: ListBox Double Click not Adding to another TextBox

    i think this is it. Thank you jindon for the help and long patience..


    God Bless You.

    ps. because of your help i receive incentive and promotion.

  14. #14
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: ListBox Double Click not Adding to another TextBox

    Quote Originally Posted by Chandria View Post
    ps. because of your help i receive incentive and promotion.
    Yes, he is for us.
    Same thing happened myself also.

    thanks Jindon sir

  15. #15
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    Re: ListBox Double Click not Adding to another TextBox

    mohan.r1980 this forum is very helpful and all the master.

  16. #16
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: ListBox Double Click not Adding to another TextBox

    Quote Originally Posted by Chandria View Post
    mohan.r1980 this forum is very helpful and all the master.
    Yes definitely,
    i really appreciate and thanks to all the experts and this forum.
    this is the best forum for me.

+ 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. Excel Double Click/Enter Listbox
    By RJ1969 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-20-2017, 11:38 PM
  2. [SOLVED] Double-click a listbox inside a group
    By rodgersmg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2015, 08:23 AM
  3. [SOLVED] Move rows from one listbox to another by double click
    By Littlefarmer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2015, 10:39 AM
  4. [SOLVED] Double Click Listbox question
    By frostii in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2015, 09:15 PM
  5. Double click Listbox to edit item
    By johan12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2012, 04:12 AM
  6. Replies: 3
    Last Post: 08-10-2011, 02:02 PM
  7. [SOLVED] Need selected item from listbox after double click
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2006, 11:20 AM

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