+ Reply to Thread
Results 1 to 6 of 6

sum using Listbox after show result in Texbox

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    sum using Listbox after show result in Texbox

    Hi how sum using Listbox after show result in Texbox?
    Please Login or Register  to view this content.
    imagine values
    12:36
    11:24
    2:13
    3:23
    4:56
    5:01
    6:00
    7:00
    8:19

    Result correct: 60:52 (h:m)

    My code show icorrect result: 00:00
    Thank you!
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: sum using Listbox after show result in Texbox

    Try
    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: sum using Listbox after show result in Texbox

    hi mike, sorry but result is 2,53611111111111, i need return 60:52

  4. #4
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: sum using Listbox after show result in Texbox

    Hi.

    I solved

    look
    Please Login or Register  to view this content.

  5. #5
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: sum using Listbox after show result in Texbox

    This worked for me
    Please Login or Register  to view this content.

  6. #6
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: sum using Listbox after show result in Texbox

    Can you help insert in my estructure code?

    Where i put your code?

+ 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. Use TexBox to filter ListBox
    By djokanice in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 01-13-2014, 12:17 PM
  2. [SOLVED] showing message box if the result of texbox doesn't match with the range then clear texbox
    By hamidrezaxy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2013, 01:04 PM
  3. Changing texbox value based on VLOOKUP result
    By anar_baku in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2011, 07:02 AM
  4. Can't get listbox which displays rows in sheet to add texbox value to selected row
    By Julesdude in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-02-2010, 01:43 PM
  5. Advanced formula - Return result & Show Cell Reference of result
    By Irv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-05-2006, 10:40 PM

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