Noob question related to IF statements, and cell population.

[JaXm]

Hey all, I'm new here, but I've seen some really helpful stuff, and am hoping to have some information I saw in an earlier thread built on.
Another user had some issues with using IF statements, and I think I can use them to solve the problem I have, but I'm not sure how.
What I would like to do, is have users (some employees of mine) input a number into a cell, for example the number "5", and instead of that cell accepting this at face value, I would like Excel to instead populate that cell, and the next four cells with a "1".
An example would be this (manually inputted of course).
4579522651.png
So Cell A9 would be "incorrect", and Cells C9-13 would be correct.
I believe using an IF statement will accomplish this, but I'm not sure how to proceed with that information.
I would be eternally grateful for any info, or help you wonderful people could provide!

[Mumps1]

For clarification: Are you saying that if a user enters a number in column A, you want column C starting at that row number in column A to have a 1 entered for as many times equal to the value in column A? Is anything to happen in column B?

[JaXm]

The example was just something I quickly made up for a visual reference.
Basically, which ever column a user picks, if they enter a value into an empty cell, that column only would be updated.

[MarvinP]

Hi JaXm and welcome to the forum,

I think you want some VBA to do what you want, like:

Please Login or Register  to view this content.

VBA for JaXm.xlsm

[JaXm]

This is really awesome! I have a question though. Can this be modified so that if a value is entered into column A, it affects column A? In your example, a value in Column A changes the values of cells in a different column (one defined by the code, in this case "C"), but is it possible to have the value of column A (whether it be 5, 4, 16000, etc) be calculated in that same column, including the inputted cell?

[MarvinP]

I think the answer to your question is YES.

The trick is to use the set the Application.EnableEvents to False so when you enter the new value into column A it doesn't trigger an event. The below code will take a number you enter into column a and multiply it by the row number.

Please Login or Register  to view this content.

[JaXm]

You've been super helpful. Would there be a resource that's readily accessible that would shed some more light on how excel uses VBA? It's been quite a while since highschool (the last time I did anything with Basic), and I'd like to refresh myself on what commands are relevant. I still have a bit of a hard time boiling down even this small amount of code into it's primary concepts.

[Mumps1]

You can start by looking at the very first thread in this forum. It is at the top and is colored in blue.