Re: $$Excel-Macros$$ help on the attached file

2010-12-21 Thread Manoj kumar
also just forgot to mention,replace the inverted comas with proper (just type them)... Regards, Manoj Kumar On Tue, Dec 21, 2010 at 2:35 PM, Manoj kumar wrote: > just remove "Option Explicit" and it is good to go... > > > Regards, > Manoj Kumar > > > On Tue, Dec 21, 2010 at 11:23 AM, poojari sr

Re: $$Excel-Macros$$ help on the attached file

2010-12-21 Thread Manoj kumar
just remove "Option Explicit" and it is good to go... Regards, Manoj Kumar On Tue, Dec 21, 2010 at 11:23 AM, poojari sreevijay wrote: > Hi team, > > Could any one please advise where i have gone wrong. > > The attached is the screenshot. > > -- > psreevi...@gmail.com > > -- > >

Re: $$Excel-Macros$$ help on the attached file

2010-12-21 Thread NOORAIN ANSARI
Dear poojari, You have use Option Explicit and Not decleared Variable. Right Code are here.. Option Explicit Sub cubeRoot() *Dim num As Integer* num = InputBox("Enter a positive number") MsgBox num ^ (1 / 3) & "Is the cube Rate." End Sub or without Varibale decleared code are here.. Sub cubeRo