+ Reply to Thread
Results 1 to 6 of 6

Userform get Adverage , Min, Max, percentage

  1. #1
    Registered User
    Join Date
    11-11-2014
    Location
    usa
    MS-Off Ver
    tn
    Posts
    23

    Userform get Adverage , Min, Max, percentage

    I have a excel work sheet that has 10 columns. in the TextBoxs I want to show the average , Min , Max, the different between the min and max the the percentage and total for column B.

    I can do this in excel with formulas but i want to use a Userform. I have added a screen shot any help is much appreciated.

    Userform.JPG
    CODE.JPG
    Last edited by booney440; 10-03-2020 at 03:15 PM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,460

    Re: Userform get Adverage , Min, Max, percentage

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,460

    Re: Userform get Adverage , Min, Max, percentage

    Duplicate of my previous post.

  4. #4
    Registered User
    Join Date
    11-11-2014
    Location
    usa
    MS-Off Ver
    tn
    Posts
    23

    Re: Userform get Adverage , Min, Max, percentage

    The percentage would be something like this.

    TextBox55.Text = Val(TextBox6) + (TextBox12) + (TextBox18) + (TextBox24) + (TextBox30) + (TextBox36) + (TextBox42) + (TextBox48) + (TextBox54)


    TextBox5.Text = Val(TextBox6.Text) / Val(TextBox55.Text) * 100
    but the results are 14.555749854276
    I want them to be 14.55%
    Last edited by booney440; 10-04-2020 at 04:54 PM.

  5. #5
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,460

    Re: Userform get Adverage , Min, Max, percentage

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    11-11-2014
    Location
    usa
    MS-Off Ver
    tn
    Posts
    23

    Re: Userform get Adverage , Min, Max, percentage

    Thank you for your help.

+ 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] Userform Formatting Not Correct for Currency and Percentage Values
    By Rudidw in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 07-26-2020, 04:46 AM
  2. Deducting percentage, calculate what percentage needs to be added to reverse
    By HereComesTheBoom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2019, 05:47 AM
  3. [SOLVED] Percentage values in combobox userform
    By Crispy85 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2017, 08:21 AM
  4. Replies: 1
    Last Post: 09-20-2016, 07:33 PM
  5. Userform Asking for percentage but cannot calculate
    By FranktheBank in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2016, 01:10 PM
  6. UserForm position based on percentage
    By rybussell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2013, 12:18 PM
  7. Transfer percentage into UserForm
    By KA_Analyst in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2007, 02:04 PM

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