+ Reply to Thread
Results 1 to 16 of 16

Evaluate textbox and display in Format

  1. #1
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Evaluate textbox and display in Format

    hello,

    I have a textbox in a USERFORM that evaluates itself.

    I want the text box to not just evaluate, but evaluate and display back in Format((Textbox1.value),"#,#")

    example :
    when I tyope 15000 + 15001 , the textbox should display 30,001

    What I tried

    Please Login or Register  to view this content.
    It gives a weird error

    I even tried :

    Please Login or Register  to view this content.

    still doesn't work... In the past I have used evaluate and have rounded the text box by using and it worked

    Please Login or Register  to view this content.
    Any help will be much appreciated
    Last edited by subbby; 05-07-2016 at 07:21 PM. Reason: Solved

  2. #2
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    858

    Re: Evaluate textbox and display in Format

    I'm not certain, but try this

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Evaluate textbox and display in Format

    Quote Originally Posted by ptmuldoon View Post
    I'm not certain, but try this
    Sorry but didn't work...says "Method or data member not found

  4. #4
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    858

    Re: Evaluate textbox and display in Format

    Can you post a sample then to help troubleshoot?

  5. #5
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Evaluate textbox and display in Format

    unable to upload the attachment although I have the same workbook...

    Its simple.. i just made the user form with two list boxes...

    and assigned my code the first one...

    it should be simple...
    meanwhile i will try again

  6. #6
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Evaluate textbox and display in Format

    tried in two different browsers.. the attachment icon is not working

  7. #7
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Evaluate textbox and display in Format

    Capture.JPG

    Tried attaching an image ... of the sample file.... hope this opens and u can see what I did... you can open new excel sheet.. hit ALT F11 and create a userform with two list boxes. and use the code I posted above (make sure the list box name is same as mentioned)

  8. #8
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    858

    Re: Evaluate textbox and display in Format

    Quote Originally Posted by subbby View Post
    tried in two different browsers.. the attachment icon is not working
    You need to "Go Advanced" to add the attachment.

  9. #9
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Evaluate textbox and display in Format

    Quote Originally Posted by ptmuldoon View Post
    You need to "Go Advanced" to add the attachment.
    I was kind fo expetcing that resposnse.. all my tries were , after I hit the "GO ADVANCED" option

    here is how that looks when I try to upload an attachment buddy


    Capture2.JPG

  10. #10
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    858

    Re: Evaluate textbox and display in Format

    Scroll down the page where is say Manage Attachments.

  11. #11
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Evaluate textbox and display in Format

    Quote Originally Posted by ptmuldoon View Post
    Scroll down the page where is say Manage Attachments.
    and then do what ?

    Although i was able to add the attachment... i wasn't able to bring it to the post ..
    do u have a solution ?



    Capture3.JPG

  12. #12
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    858

    Re: Evaluate textbox and display in Format

    Subbby

    After you attach the file, you just close the attachment window and it will return you to your post with the attachment. I can't see what could be causing you to not be able to attach something.

  13. #13
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Evaluate textbox and display in Format

    see thread # 15
    Last edited by subbby; 05-06-2016 at 06:39 PM.

  14. #14
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Evaluate textbox and display in Format

    let me try from a different computer ....

    Thanks for your patience

  15. #15
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Evaluate textbox and display in Format

    I tried again... went to manage window.. attached the excel.... pressed the upload option... close the window, cam e back here and I see no attachment...

    however I am posting this... just to see if the attachment goes thru
    Attached Files Attached Files

  16. #16
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Evaluate textbox and display in Format

    SOLVED

    used the following code....


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

+ 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. Display Full Text within Textbox (On A UserForm) when you hover over the textbox
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-20-2015, 09:01 AM
  2. [SOLVED] Excel 2010 - Userform - display date from textbox in a label or textbox in 'ddd' format
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2015, 10:54 PM
  3. Excel 2010 – VBA Userforms – Vlookup via Textbox, display result in another textbox
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2015, 12:31 AM
  4. MultiLine TextBox line count to display in label or textbox
    By khhoa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2015, 06:02 PM
  5. [SOLVED] TextBox display format currency query
    By gogreenpower in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-25-2014, 11:52 PM
  6. Textbox to display a number or currency format
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2011, 11:00 PM
  7. Display value in textbox format decimal places
    By alex3867 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2007, 07:20 AM

Tags for this Thread

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