Multiplying values on userform

OfficeUser · Jul 8, 2011

I am trying to multiply 2 values on a userform using this line of vba:

Code:

lblChromeTotal = Format((rFound.Offset(0, 3).Value), "0.00")

I need to multply the value in lblChromeTotal by a textbox labeled txtPercentile.

I figured this would work but is giving me problems:

Code:

lblChromeTotal = Format(((rFound.Offset(0, 3).Value) * txtPercentile.Value), "0.00")

Any suggestions on making it work as intended? Thank You.

VoG · Jul 8, 2011

Perhaps

Code:

lblChromeTotal = Format(rFound.Offset(0, 3).Value * Val(txtPercentile.Value), "0.00")