+ Reply to Thread
Results 1 to 7 of 7

Double click in listbox returning wrong value for date

  1. #1
    Registered User
    Join Date
    10-05-2019
    Location
    Northampton
    MS-Off Ver
    latest
    Posts
    29

    Double click in listbox returning wrong value for date

    in a list box i have several col of data, all bar one col returns correctly.

    col B displays a date,

    when i double click on list box data from that row fills text box's but only the date return incorrectly

    instead of the text box showing 12/10/2019 it shows 43723

    ive been trying to work on this all day but no luck

    by the way this is on a userform

    here is my code for my list box

    Please Login or Register  to view this content.
    Last edited by Rocky01; 10-20-2019 at 11:19 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Double click in listbox returning wrong value for date

    Place the file or the complete code. Now we cannot see how Listbox1 is filled. It is also not clear which TextBox is involved.

  3. #3
    Registered User
    Join Date
    10-05-2019
    Location
    Northampton
    MS-Off Ver
    latest
    Posts
    29

    Re: Double click in listbox returning wrong value for date

    file should now be attached - has macros (SAFE)
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Double click in listbox returning wrong value for date

    I can't find a front or back in it. Have you made this yourself or found it somewhere?
    In the example how you can do it.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-05-2019
    Location
    Northampton
    MS-Off Ver
    latest
    Posts
    29

    Re: Double click in listbox returning wrong value for date

    Quote Originally Posted by Vraag en antwoord View Post
    I can't find a front or back in it. Have you made this yourself or found it somewhere?
    In the example how you can do it.
    thats exact what im after but cant seem to add it to my code

  6. #6
    Registered User
    Join Date
    10-05-2019
    Location
    Northampton
    MS-Off Ver
    latest
    Posts
    29

    Re: Double click in listbox returning wrong value for date

    Quote Originally Posted by Vraag en antwoord View Post
    I can't find a front or back in it. Have you made this yourself or found it somewhere?
    In the example how you can do it.
    i got this from onlinepclearning and what you do mean you can't find front or back in it??

  7. #7
    Registered User
    Join Date
    10-05-2019
    Location
    Northampton
    MS-Off Ver
    latest
    Posts
    29

    Re: Double click in listbox returning wrong value for date

    Quote Originally Posted by Vraag en antwoord View Post
    I can't find a front or back in it. Have you made this yourself or found it somewhere?
    In the example how you can do it.
    Many Thanks it works just needed to work out how to input your code into mine. all sorted many thanks

+ 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. [SOLVED] ListBox Double Click not Adding to another TextBox
    By Chandria in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-24-2017, 04:11 AM
  2. Excel Double Click/Enter Listbox
    By RJ1969 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-20-2017, 11:38 PM
  3. [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
  4. [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
  5. [SOLVED] Double Click Listbox question
    By frostii in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2015, 09:15 PM
  6. Double click Listbox to edit item
    By johan12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2012, 04:12 AM
  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