+ Reply to Thread
Results 1 to 12 of 12

Get statistical results in text boxes of userform.

  1. #1
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Get statistical results in text boxes of userform.

    Hello

    My goal is this.

    When the user choose a customer from a combo box then i need to get some statistical results in the text boxes, such as last amount of credit-charge, last date, and amount that he has to pay us until now.
    When user adds a new amount in the grey textbox then this has to be added in the previous amount.

    I have the expected results of my example in my sample sheet.

    Thanks in advance for any help.
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Get statistical results in text boxes of userform.

    May need some fine tuning.
    Attached Files Attached Files
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Get statistical results in text boxes of userform.

    Hello

    This works great. Thank you!

    Now my problem is that i try to add this code with another one that you offered to me in another thread a few days ago and i get an Error "Can't find a project or library and highlight the red part of the code!

    Can you pls take a look on this?

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

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Get statistical results in text boxes of userform.

    Try to change the ChargeDate declaration to a string.
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Get statistical results in text boxes of userform.

    Thanks for your reply. Unfortunately this does not helps. Same error!

    Take a look to the video pls!

    http://screencast.com/t/pwld0zqR

  6. #6
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Get statistical results in text boxes of userform.

    I don't get that error. Make sure the reference are set.
    Error.jpg
    Last edited by Tinbendr; 07-01-2014 at 07:41 AM.

  7. #7
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Get statistical results in text boxes of userform.

    The reference is checked as you show me in your pic.

    Must be something in the combination of the 2 different codes but i am not able to find what happens ...

    Did you open my attachment(post#3) and everything works for you?

  8. #8
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Get statistical results in text boxes of userform.

    Yes. I purposely d/l your attachment, but did not get error. I watched your screen grab and selected the same as you. Strange!???

  9. #9
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Get statistical results in text boxes of userform.

    Here's an link that looks promising.

  10. #10
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Get statistical results in text boxes of userform.

    Maria try with this highlighted red part of the code and tell us what happens.

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

    Note: Changing of course the
    Please Login or Register  to view this content.
    as Tinbendr suggested!
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  11. #11
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Get statistical results in text boxes of userform.

    Quote Originally Posted by Fotis1991 View Post
    Maria try with this highlighted red part of the code and tell us what happens.
    Note: Changing of course the
    Please Login or Register  to view this content.
    as Tinbendr suggested!
    What happens? The same as every time that you suggest something Mr Foti!! Works like a charm!!!

    Many thanks to both of you!!

  12. #12
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Get statistical results in text boxes of userform.

    Tinbendr is the one that deserves the thanks. Nice work!

+ 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] Clear all text boxes-combo boxes in a userform.
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2014, 11:16 AM
  2. [SOLVED] Help with code for userform text boxes, combo boxes and excel
    By innerise in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-20-2014, 09:07 AM
  3. Text Boxes On UserForm vs Wizard
    By stuu3270 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2013, 07:09 PM
  4. multiple text boxes on userform
    By stephen1000 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-18-2009, 03:37 AM
  5. [SOLVED] Using userform, text boxes
    By Momo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2005, 12:06 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