AutoFill When A Cell Inputted With Data

**esawah** · 01-14-2010, 02:17 AM

How would I go about getting a cell to be autofill with a word once the user inputs data in the adjacent cell

For example:

A1 would initially be blank. When the user types into B1, A1 is automatically filled with the word "True". When the user types into B2, A2 is automatically filled with the word "True." And so on.

So the goal is to only have column A (specifically, a range in column A) be filled with the word "True" if there is data is inputted in column B(specifically, a range in column B).

I am new to programming in VBA, so I am cluelessly how to accomplish this.

**Paul** · 01-14-2010, 02:21 AM

You wouldn't need VBA for this, you can use a simple IF formula.

In A1 put:

=IF(ISBLANK(B1),"","True")

Fill that down as many rows as you need to in column A.