Input Box Value Help

**Kaustubh1040** · 06-14-2019, 03:02 PM

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.

**6StringJazzer** · 06-14-2019, 03:17 PM

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.

**Kaustubh1040** · 06-14-2019, 03:23 PM

This is what I get when I run the code

Please Login or Register  to view this content.

My Answer is Zero

**Kaustubh1040** · 06-14-2019, 03:38 PM

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

But, thanks for the help.

**6StringJazzer** · 06-14-2019, 03:51 PM

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

Input Box Value Help

LinkBack

Thread Tools

Rate This Thread

Display

Input Box Value Help

Re: Input Box Value Help

Re: Input Box Value Help

Re: Input Box Value Help

Re: Input Box Value Help

Thread Information

Users Browsing this Thread

Similar Threads

Macro to generate daily input and retrieve historical input

Need function to Populate column adjacent to input cell based off input.

Data Input Form with number of line items based on user input

[SOLVED] input date column A, increment B, select blank cell in D and input time. in a macro

[SOLVED] Macro to manually input which field (column) to autofilter on using an input prompt

Automatic Formula Input Based on User Input Using a Macro

Using text box input to lookup number and replace based on user input into new column

Bookmarks

Bookmarks

Posting Permissions