Allow entry in target.cell and exceute code once

[excel_vb]

Please help me understand if there is a better way to code the below
What I want to accomplish:

• If col A =yes, if user is currently in col C cell and col B is blank, then mesg and back to col A.
• If col B not blank, then excute code

.

My problem is that the code exceutes everytime user is in col C and user cannot enter value in column c. I want this to execute only when col A changes from yes to no OR when value in col B changes. I also want to be able to change the value in col C
What should I be doing differently?

Please Login or Register  to view this content.

[Palmetto]

You dont need a For loop to do this. Just set the range of cells to the applicable rows per the target column.

Please Login or Register  to view this content.

I also want to be able to change the value in col C

Change it to what? When? The user will aready be in this column when the code fires (assuming A=Yes and B=blank). Be more specific.

[excel_vb]

Sorry, I was not clear before.
I'm creating a form in excel wherein user requests for new accounts.
With each form, user can request upto 23 accounts(each row from 2-25 requests details/ information about a new acct)
the way it works is that user navigates from A2 to B2 to C2 and so forth providing information in each row for every new acct. If user wants new account to be modelled after existing acct, they say 'yes' in column A, then provide existing acct nbr in col B, based on which cells in col C-H will self-populate based on a vlookup of the existing acct. User is not allowed to modify cells E-H, but can go back after the vlookup runs and change the values in col C and D.
That is why I asked in my earlier post how to go about changing value of cell in col C because the way I had my code, every time I clik on cell C, the code runs and cursor stops at H. The only cell I cannot modify is in col C.