Total
72
86
75
10
80
I wanna sort this numbers from the highest value to lowest and I don't know how to arrange it by using array formula.I will be thankful for the code.
Thank You....
User Profile
Collapse
Profile Sidebar
Collapse
piper09
Last Activity: Mar 5 '13, 09:19 AM
Joined: Feb 19 '13
Location:
-
Call Function ?
...Code:Private Sub I1_Click() TotalI = Val(I1) + Val(I2) + Val(I3) + Val(I4) WgtI = TotalI / 40 * 30 T1.Cls W1.Cls TotalW.Cls T1.Print TotalI W1.Print WgtI TotalWgt = WgtI + WgtII + WgtIII TotalW.Print TotalWgt End Sub Private Sub I2_Click() TotalI = Val(I1) + Val(I2) + Val(I3) + Val(I4) WgtI = TotalI / 40 * 30 T1.Cls W1.Cls TotalW.Cls T1.Print TotalI
-
Round up the wgt ?
TotalII = Val(II1) + Val(II2) + Val(II3) + Val(II4)
WgtII = TotalII / 40 * 50
After I total up II1-4
Then I will be getting the answers in round up number but for wgt II I getting in decimal place ? -
How to display the year on printer ?
I got the code for auto year generate on the form but I can't display the year on printed paper ?
This is the code for display an auto year
tyy = LTrim(Str(DateP art("yyyy", Date)))
TCYY.Cls
TCYY.Print tyy
tyy = tyy - 1
tyy = LTrim(tyy)
TPYY.Cls
TPYY.Print tyy
And the code for printer
Printer.Current X = 70
Printer.Current Y = 15... -
How to convert Decimal place to round number ?
I need to display 26.25 as 26 what is the format i need to use in vb 6.0. -
I want to auto generate this Year 2011/2012 to 2012/2013....this thing is in a form and it will be reused again...and its done in a commandbox in VB6. -
How to generate an automatic label Year ?
I can't manage to find the code for Year as stated above in the title. Can u guyz help me with it. I already attach the image of the file .
Thank Tou....
No activity results to display
Show More
Leave a comment: