VB Next?

I have reached the maximum threshold of 8 IF statements in 1 cell but have more I need to enter. I think I should now use some VB code to enter the entire list of conditions I have. I am really inexperienced when it comes to VB so can someone get me started on the syntax? Thank you.

If you outline what it is you are trying to do, maybe there is an alternate solution to VB. There are ways to shorten the number of nested if statements.


Steve

Likely, you can create a table of IF in one column, THEN in the second
column, and use a vlookup:
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"msals22" <[email protected]> wrote in
message news:[email protected]...
>
> I have reached the maximum threshold of 8 IF statements in 1 cell but
> have more I need to enter. I think I should now use some VB code to
> enter the entire list of conditions I have. I am really inexperienced
> when it comes to VB so can someone get me started on the syntax? Thank
> you.
>
>
> --
> msals22
> ------------------------------------------------------------------------
> msals22's Profile:
> http://www.excelforum.com/member.php...o&userid=30908
> View this thread: http://www.excelforum.com/showthread...hreadid=506953
>

Originally Posted by Anne Troy

Likely, you can create a table of IF in one column, THEN in the second
column, and use a vlookup:
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"msals22" <[email protected]> wrote in
message news:[email protected]...
>
> I have reached the maximum threshold of 8 IF statements in 1 cell but
> have more I need to enter. I think I should now use some VB code to
> enter the entire list of conditions I have. I am really inexperienced
> when it comes to VB so can someone get me started on the syntax? Thank
> you.
>
>
> --
> msals22
> ------------------------------------------------------------------------
> msals22's Profile:
> http://www.excelforum.com/member.php...o&userid=30908
> View this thread: http://www.excelforum.com/showthread...hreadid=506953
>

Anne-
After a little trial and error I got it...thanks!

You're welcome!
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"msals22" <[email protected]> wrote in
message news:[email protected]...
>
> Anne Troy Wrote:
>> Likely, you can create a table of IF in one column, THEN in the second
>> column, and use a vlookup:
>> http://www.officearticles.com/excel/...soft_excel.htm
>> ************
>> Hope it helps!
>> Anne Troy
>> www.OfficeArticles.com
>>
>> "msals22" <[email protected]> wrote
>> in
>> message news:[email protected]...
>> >
>> > I have reached the maximum threshold of 8 IF statements in 1 cell
>> but
>> > have more I need to enter. I think I should now use some VB code to
>> > enter the entire list of conditions I have. I am really
>> inexperienced
>> > when it comes to VB so can someone get me started on the syntax?
>> Thank
>> > you.
>> >
>> >
>> > --
>> > msals22
>> >
>> ------------------------------------------------------------------------
>> > msals22's Profile:
>> > http://www.excelforum.com/member.php...o&userid=30908
>> > View this thread:
>> http://www.excelforum.com/showthread...hreadid=506953
>> >
> Anne-
> After a little trial and error I got it...thanks!
>
>
> --
> msals22
> ------------------------------------------------------------------------
> msals22's Profile:
> http://www.excelforum.com/member.php...o&userid=30908
> View this thread: http://www.excelforum.com/showthread...hreadid=506953
>