Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple question?? Nested ifs on one line
I'm using Excel 2003.
This seems like it should be very simple, but I've tried lots of things, and nothing works. I have a large amount of "checks" to do so I would like to put 2 if statements on one line. I'd like to put this on one line: If OneH < "" then If OneH = YNewH then goto DisplayMsg end if end if Your help would be GREATLY appreciated! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple question?? Nested ifs on one line
sub ONEline()
If OneH < "" and OneH = YNewH then goto DisplayMsg end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "laavista" wrote in message ... I'm using Excel 2003. This seems like it should be very simple, but I've tried lots of things, and nothing works. I have a large amount of "checks" to do so I would like to put 2 if statements on one line. I'd like to put this on one line: If OneH < "" then If OneH = YNewH then goto DisplayMsg end if end if Your help would be GREATLY appreciated! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple question?? Nested ifs on one line
You do not need two IF statements to accomplish the end product:
If OneH = YNewH Then GoTo DisplayMsg End If The logic is that if OneH equals YNewH then it obviously is not equal to the empty string. But if you still want to check for the empty string, you can: If OneH < "" And OneH = YNewH Then GoTo DisplayMsg End If If you are asking whether the If statements can be nested, the answer is yes, but I believe there is a limit of about 15 and each one must have an End If. It might be easier to use the If...ElseIf...Else...End If format. That format will handle many comparisons. See VBA help file for details. Example: If OneH < "" Then 'Do something or do nothing ElseIf OneH = YNewH Then GoTo DisplayMsg Else 'Exit Sub maybe End If "laavista" wrote in message ... I'm using Excel 2003. This seems like it should be very simple, but I've tried lots of things, and nothing works. I have a large amount of "checks" to do so I would like to put 2 if statements on one line. I'd like to put this on one line: If OneH < "" then If OneH = YNewH then goto DisplayMsg end if end if Your help would be GREATLY appreciated! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple question?? Nested ifs on one line
How about:
======== If OneH < "" And OneH = YNewH The Goto DisplayMsg ======== -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "laavista" wrote: I'm using Excel 2003. This seems like it should be very simple, but I've tried lots of things, and nothing works. I have a large amount of "checks" to do so I would like to put 2 if statements on one line. I'd like to put this on one line: If OneH < "" then If OneH = YNewH then goto DisplayMsg end if end if Your help would be GREATLY appreciated! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple question?? Nested ifs on one line
IT WORKED!! THANK YOU so much for taking the time to answer my question.
If was trying to add the "end if" at the end of the statement to no avail. Thanks again. I really appreciate it! "JBeaucaire" wrote: How about: ======== If OneH < "" And OneH = YNewH The Goto DisplayMsg ======== -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "laavista" wrote: I'm using Excel 2003. This seems like it should be very simple, but I've tried lots of things, and nothing works. I have a large amount of "checks" to do so I would like to put 2 if statements on one line. I'd like to put this on one line: If OneH < "" then If OneH = YNewH then goto DisplayMsg end if end if Your help would be GREATLY appreciated! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple question?? Nested ifs on one line
Wouldn't it be easier just to write it as
If OneH = YNewH Then Goto DisplayMsg If YNewH is anything, then it's not going to be blank, so for OneH to = YNewH, then OneH can't be "", by definition. Of course, if there's a possibility that YNewH could be = "", then the way you have it now is the better way to go (and one that would work properly if YNewH can sometimes be ""). "laavista" wrote: IT WORKED!! THANK YOU so much for taking the time to answer my question. If was trying to add the "end if" at the end of the statement to no avail. Thanks again. I really appreciate it! "JBeaucaire" wrote: How about: ======== If OneH < "" And OneH = YNewH The Goto DisplayMsg ======== -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "laavista" wrote: I'm using Excel 2003. This seems like it should be very simple, but I've tried lots of things, and nothing works. I have a large amount of "checks" to do so I would like to put 2 if statements on one line. I'd like to put this on one line: If OneH < "" then If OneH = YNewH then goto DisplayMsg end if end if Your help would be GREATLY appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple nested if statement | Excel Discussion (Misc queries) | |||
simple nested loop question | Excel Programming | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple Question (insert new line) | Excel Programming | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) |