thank you so much sam

On Wed, Sep 7, 2011 at 7:47 PM, GoldenLance <samde...@gmail.com> wrote:

> TextBox2.Text = Application.RoundUp(Val(TextBox1.Text), 0)
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
> On Sep 7, 6:52 pm, Shankar Bheema <shankar.n...@gmail.com> wrote:
> > I am attaching an excel file with inserted userform.
> >
> > I have given command button to roundoff the figure in textbox1.text to
> the
> > next higher rupee.  I have given the code as
> >
> > textbox2.text=Round(val(textbox1.text),0)
> >
> > but its returning wrong result.
> >
> > if i have given 100.1 in textbox1.text
> >
> > the result should be 102 in textbox2.text
> >
> >  rounding doubt.xls
> > 33KViewDownload
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to