VB script to compare text, if not available do something else

Hi Experts,

This is my first post - I've been reading and getting lots of help on my own.

What i'm trying to do is build a form for my end users. for a certain field i want them to enter text. i'd like a macro that takes that text and compares it to a set table on another sheet that i've Named.

Example.

Cell D19 = spot users will enter data

Sheet Other A20 - A256 (A20:A256) is the list, i have it named Ext_Mat_Group

If a users enters a Ext_Mat_Group that is in the list do nothing.
Else "(What they entered) - NEW"

Thanks,

Dex

I had to read your post a couple of times because it is a little confusing. Do you mean like this?

Please Login or Register  to view this content.

Hi Stnkynts,

To sum everything up i've said in the previous post.

I want to compare an entered text from the customer with a List that i've named using the Name Manager.

If the Name is in the list do nothing. if it isn't in the list. i want what they entered to remain and the macro to add -NEW

I'm going to give your code a shot here and see what happens. i think you can ignore the sheet pages because with the Name Manager it doesn't require me to list out sheets.

Keep in mind that i'm fiarly new to macro's in Excel and it may be painful for you to understand my lingo

Thanks!

Populated your Code, it works great. i just need it to put the value you in instead of a MsgBox . i was thinking a concatenate of what they typed with -New? (am i complicating things?)

Regards,
Dex

So you are saying you need to add the new value to the existing named range (Ext_Mat_Group) then resize that named range so it incorporates the new value?

No need to add to existing range, just need it to stay in D19 with "-NEW" at the end of what they typed. I'll maintain the existing list from SAP.