Re: $$Excel-Macros$$ rounding to next higher rupee

2011-09-07 Thread Shankar Bheema
ya its working. amazing. thank you so much On Wed, Sep 7, 2011 at 9:48 PM, NOORAIN ANSARI wrote: > see if it help > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ rounding to next higher rupee

2011-09-07 Thread NOORAIN ANSARI
see if it help -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Sep 7, 2011 at 7:22 PM, Shankar Bheema wrote: > I am attaching an excel file with i

RE: $$Excel-Macros$$ rounding to next higher rupee

2011-09-07 Thread Daniel
: excel-macros@googlegroups.com Objet : $$Excel-Macros$$ rounding to next higher rupee 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

$$Excel-Macros$$ rounding to next higher rupee

2011-09-07 Thread Shankar Bheema
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 resu