+ Reply to Thread
Results 1 to 2 of 2

Userform textbox output to one decimal place

  1. #1
    Registered User
    Join Date
    02-06-2015
    Location
    Exeter
    MS-Off Ver
    2013
    Posts
    8

    Userform textbox output to one decimal place

    Hi All,

    I have an output in one of my textboxes in my userform that returns a number to four decimal places. Ideally I would like the output value to be given to one decimal place. I currently have the below code, however it isn't working for me. Any help would be much appreciated.

    Please Login or Register  to view this content.
    Thank you in advance,

    Tubes

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Userform textbox output to one decimal place

    Try this, then you don't need the TextBox7.Text line after it:

    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. Userform Textbox to store value in excel the number losing decimal
    By Jaco Smit in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-26-2014, 07:42 AM
  2. [SOLVED] Convert Userform textbox to decimal number
    By Leandrial in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2012, 02:08 PM
  3. Userform to search textbox value to place other textbox values in worksheet
    By mattyh555 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2012, 11:38 AM
  4. [SOLVED] Place data from VBA Userform TextBox into a new row on a worksheet every time
    By Sugarray in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2012, 08:51 AM
  5. [SOLVED] Need help with decimal place output using IMPRODUCT formula.
    By sergiob in forum Excel General
    Replies: 10
    Last Post: 06-27-2012, 08:12 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