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.
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.
Duplicate of my previous post.
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.
Please Login or Register to view this content.
Thank you for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks