If cell contains this then do this

[ija34]

Okay, so I've been scouring the internet for info on if statements and I can only seem to find if statements that check if a cell contains ANY text. What I'm looking for is something like this...

If the cell in Range(enter range) contains (type text her) then perform the following code

or

If cell contains this text then perform this different code

I already have the correct codes written out which is working correctly. I just need to make it dependent on text in a different cell. So basically I have an account statement for two different accounts but they appear on the same statement. So when I process a transaction, I want it to bring the correct amount from the balance section for the correct account.

Therefore, when cell says "Account 1" it should go and bring my current balance from account 1 and when the cell says "Account 2" it should go and bring me my balance from account 2. Thanks in advance. Current code I have for this macro is pasted below.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

There is no way to tell from your code what cell you want to check for "Account 1" and how to bring the balance from account 1.

I suggest you attach your Excel file so we can see where your data is. See yellow banner at the top of the page.

But here is the generic answer to the generic part of your question:

Please Login or Register  to view this content.

[ija34]

I have uploaded the file so hope this will allow you see what I'm trying to do.

[ija34]

There is no way to tell from your code what cell you want to check for "Account 1" and how to bring the balance from account 1.

I suggest you attach your Excel file so we can see where your data is. See yellow banner at the top of the page.

But here is the generic answer to the generic part of your question:

Please Login or Register  to view this content.

Uploaded, if you click the process button on the set-up sheet. That's where I'm up to so far so when it adds the money to previous balance. I need that to be dependent on the account and bring the balance from the banking sheet.

[ija34]

Nevermind, the generic code worked, thanks

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking Add Reputation below their name.