NEW TO VBA NEED HELP PLEASE!! thank you :)

**awale** · 08-27-2015, 06:26 AM

Hello Everyone.

I am having problems with a VBA Excel 2010 program code.

I am trying to read data from a spreadsheet on excel 2010. what I have is a set of data (see below) and I am trying to write a code that will let me use a msg box and ask me to write down the name I am looking for e.g. "Name 1" from the list of names in the column and then I want to set a criteria where if the number in the columns are equal to zero and again for a different column = 0 ("name 5"), then highlight red any number in column "Name 8 and Name 9" that is greater than let say 30 (just a random example). the important thing is, the red highlight of column "Name 8/9" must only occur if the numbers is row "Name 1" and "Name 5" are equal to zero.

I have already done this but I only used the column numbers e.g. A1:A5. now I need to use the name of the column because I want to use the code for a different excel spreadsheets but the names of columns are in different positions for each excel sheet, but if I use the names, no matter which column along excel they are I will always find the right column I am looking for and set the criteria.

the criteria for "Name 1/5" will always be = 0 or =1 but the program has to ask me to choose that when I search for it.

if you look below at the example, you can see the red highlight are when criteria of =0 is met for Name 1 and Name 5 and the number in Name8/9 are greater than 30. when it is not greater than 30 and it still meets the criteria it is highlighted blue in the excel spreadsheet example. ALL OTHER NAMES MUST BE IGNORED.

SEE ATTACHED EXAMPLE hopefully this will make sense. “hopefully"

**Pepe Le Mokko** · 08-27-2015, 09:02 AM

Please take a moment to read forum rules and adapt your title accordingly - Thx

**awale** · 09-03-2015, 03:42 AM

THIS IS WHAT I HAVE SO FAR

Please Login or Register  to view this content.

I want to be able to search for three three diffeent name and set the criteria( a message box that asks me whether I want it to be 1 or 0 ). so search name 1 ask me for criteria , 1 or 0 then name 2 then name 3.

**Pepe Le Mokko** · 09-08-2015, 06:29 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**Fotis1991** · 09-14-2015, 10:36 AM

So welcome to the forum. Pls take some minutes to read carefully the forum rules and be sure that you'll comply with them.

In this case your posts don't comply with Rule#1--Rule#7 AND Rule#6 of our forum. Not real a good start here.

So until to change your title as per request, no one will be able to helps you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)