| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. -- msals22 ------------------------------------------------------------------------ msals22's Profile: http://www.excelforum.com/member.php...o&userid=30908 View this thread: http://www.excelforum.com/showthread...hreadid=506953 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
VB Next?
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
VB Next?
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 -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=506953 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
VB Next?
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" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
VB Next?
You're welcome!
************ Hope it helps! Anne Troy www.OfficeArticles.com "msals22" wrote in message ... 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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
