hi,
Step1:I have created a userform which fills the data entered to an excel sheet--> i am able to do this part -->Step2: i want to open a new userform which would display data from the excel sheet in label box's on the userform.
note : I am able to open the new user form if there is data already on the excel sheet.
in short there is a cell which contains this formula "=IF(E3>0,E3/F3*100,E3/F3*100)" & "=IF($F$3>0,$F$3/$E$3*100,$F$3/$E$3*100)" which cause the error.
formula used for label reference :
UserForm1.GrandTotalper1.Caption = Range("e2").Value
UserForm1.GrandTotalper2.Caption = Range("f2").Value
also if someone can help me on display properties for the label box :
I want the box to display only 2 digits after the decimal, but I am unable to do so.
Appreciate UR help!!!
Step1:I have created a userform which fills the data entered to an excel sheet--> i am able to do this part -->Step2: i want to open a new userform which would display data from the excel sheet in label box's on the userform.
note : I am able to open the new user form if there is data already on the excel sheet.
in short there is a cell which contains this formula "=IF(E3>0,E3/F3*100,E3/F3*100)" & "=IF($F$3>0,$F$3/$E$3*100,$F$3/$E$3*100)" which cause the error.
formula used for label reference :
UserForm1.GrandTotalper1.Caption = Range("e2").Value
UserForm1.GrandTotalper2.Caption = Range("f2").Value
also if someone can help me on display properties for the label box :
I want the box to display only 2 digits after the decimal, but I am unable to do so.
Appreciate UR help!!!
Last edited: