Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Goto in IF statment
I cannot remember how, I think I did it before, to add a goto to an IF
statement. Anyone have any ideas? Thanks! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
|
|||
|
|||
If this is a cell formula, there's no meaning for goto. Only results are
returned in cells. Actions are not taken. If this is a macro question, post back. What's all that stuff about the most votes? This isn't a democracy. :) -- Earl Kiosterud www.smokeylake.com "=\" wrote in message ... I cannot remember how, I think I did it before, to add a goto to an IF statement. Anyone have any ideas? Thanks! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#3
|
|||
|
|||
Hi Earl,
What I am trying to do is create a function (or macro if possible, I haven't done one in years) that will basically say when someone is filling out a request... 'IF Yes to being a member then jump a couple of rows and then complete the rest of the information'..is this possible or should I just give up and create another spreadsheet? =) Thanks, Colleen "Earl Kiosterud" wrote: If this is a cell formula, there's no meaning for goto. Only results are returned in cells. Actions are not taken. If this is a macro question, post back. What's all that stuff about the most votes? This isn't a democracy. :) -- Earl Kiosterud www.smokeylake.com "=\" wrote in message ... I cannot remember how, I think I did it before, to add a goto to an IF statement. Anyone have any ideas? Thanks! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#4
|
|||
|
|||
Colleen,
I don't think I have a clear enough picture of what's going on to give much of an answer. It sounds as if you need a worksheet_change macro to watch that cell, and if "Yes" is entered, move the selected cell to the new location two rows down. -- Earl Kiosterud www.smokeylake.com "=\" wrote in message ... Hi Earl, What I am trying to do is create a function (or macro if possible, I haven't done one in years) that will basically say when someone is filling out a request... 'IF Yes to being a member then jump a couple of rows and then complete the rest of the information'..is this possible or should I just give up and create another spreadsheet? =) Thanks, Colleen "Earl Kiosterud" wrote: If this is a cell formula, there's no meaning for goto. Only results are returned in cells. Actions are not taken. If this is a macro question, post back. What's all that stuff about the most votes? This isn't a democracy. :) -- Earl Kiosterud www.smokeylake.com "=\" wrote in message ... I cannot remember how, I think I did it before, to add a goto to an IF statement. Anyone have any ideas? Thanks! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cursor goto a5 in Sheet1 but | Excel Worksheet Functions | |||
Using 'GoTo' in a Macro | Excel Discussion (Misc queries) | |||
Goto a dynamic cell address within a macro | Excel Discussion (Misc queries) | |||
Goto Data validation Same ERROR | Excel Discussion (Misc queries) | |||
Validation Data & Goto question | Excel Discussion (Misc queries) |