VBA Code word for text string comparison...

[jgleon22]

Hey!

I would like to know what code word should I use thato allow the program to read and compare text strings within VBA.

for instance I have three columns

A | B | C

In column A, I will type the name of a thing (i.e. apples and pears)
In column B I will type the amount of apples or pears that I ate on day 1
In column C, I will type the amount of apples our pears that I ate on day 2

Therefore the code should have the following format

Please Login or Register  to view this content.

Let me know... Thanks!

[GuruWannaB]

Why in VBA? - this would be so much easier to do in a formula.

[Leith Ross]

Hello jgleon22,

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

Use the Bulletin Board Code Tags
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line.


As a member, You have agreed to follow the forum posting rules. Please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules

[jgleon22]

GuruWanaB:

Hey! I am trying to do it using only VBA codes. I just need to know the codeword that will enable the code to differentiate between text strings.

Let me know,
Thanks!

[romperstomper]

You would need to loop through each cell in column A, check if the text equals the value you want, then add up the other columns if so.