gt; excel-macros@googlegroups.com] *On Behalf Of *Shankar Bheema
> *Sent:* Jan/Thu/2012 12:31
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ doubt with rounding off and change event in
> excel vba
>
> ** **
>
> Dear Experts
>
> I am attaching a
Use Mround Function
See the attached file
Regards
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shankar Bheema
Sent: Jan/Thu/2012 12:31
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ doubt with rounding off and change event
Dear Experts
I am attaching an excel vba file. In which I am facing a problem with
change event.
the addition of textbox2.text + textbox3.text values with the value of 3%
of the value of the above both. That 3% value if exceeds 1 rupee it should
be rounded off to the next nearest 10 rs.
eg: i