Hi,
**
*Try it in Userform:*
Private Sub CommandButton1_Click()
TextBox2.Text = WorksheetFunction.Ceiling((Val(TextBox1.Text) * 0.03) -
0.8, 10)
End Sub
Regards,
MARIES.
On Wed, Feb 29, 2012 at 2:58 PM, Shankar Bheema wrote:
> Dear Experts
>
> The above attached file contains an userform for r
Dear Experts
The above attached file contains an userform for rounding off of the value
if the 3% of the given value comes to more than multiple of 10 except the
fraction that value should be rounded off to the nearest multiple of 10
ex. if the value of 3% comes to 660.01 or 660.50 or 660.99 th
