VBA Code word for text string comparison...

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

if(Range "A3:A10"="APPLE)
THEN 
 =sum(B3:C3)
END IF
IF(RANGE"A3:A10" = "PEAR") 
THEN 
=sum(B3:C3)

ENDIF

Let me know... Thanks!

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] at the start of the first line,
[/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

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.