+ Reply to Thread
Results 1 to 5 of 5

Input Box Value Help

  1. #1
    Registered User
    Join Date
    11-07-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    23

    Input Box Value Help

    Hello Friends

    Why I am getting '0' answer while using this formula. What wrong I am doing her
    Please Login or Register  to view this content.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    14,426

    Re: Input Box Value Help

    I can't tell why you are using FormulaArray instead of Formula, but you do have a syntax problem. I can't test it without your file but try this:

    Please Login or Register  to view this content.
    Jeff

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會

    If someone helped you please click on the star icon at the bottom of their post
    If your problem is solved please go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  3. #3
    Registered User
    Join Date
    11-07-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    23

    Re: Input Box Value Help

    This is what I get when I run the code

    Please Login or Register  to view this content.
    My Answer is Zero

  4. #4
    Registered User
    Join Date
    11-07-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    23

    Re: Input Box Value Help

    It is working now. The problem was with the name. I was using 'mymnths' instead of 'mymnth'. So silly.

    But, thanks for the help.

  5. #5
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    14,426

    Re: Input Box Value Help

    I strongly recommend to everyone that they declare variables. Doing so prevents a lot of bugs and runtime errors.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1