| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit due to selected cells
G'morning,
I have a to-do-list in Excel consisting of 5 columns (A:E). Every new task is on a new row. If needed I can create tasks in Outlook with the help of commandbutton (which has code assigned to it that extracts the info I need to the body of the task). What I would like to do now is to create an extra statement (within the current statement) that states that if I'm not in a cell in column D the code behind the commandbutton does not work (to prevent faults or tasks that are unclear). Any help would be greatly appreciated. Regards, Basta 1980 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit due to selected cells
Try
If ActiveCell.Column < 4 Then 'your current code End If OR place the below on top of your current procedure If ActiveCell.Column = 4 Exit Sub -- Jacob (MVP - Excel) "Basta1980" wrote: G'morning, I have a to-do-list in Excel consisting of 5 columns (A:E). Every new task is on a new row. If needed I can create tasks in Outlook with the help of commandbutton (which has code assigned to it that extracts the info I need to the body of the task). What I would like to do now is to create an extra statement (within the current statement) that states that if I'm not in a cell in column D the code behind the commandbutton does not work (to prevent faults or tasks that are unclear). Any help would be greatly appreciated. Regards, Basta 1980 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit due to selected cells
Jacob,
Thnx again. Works like a charm Regards Basta1980 "Jacob Skaria" wrote: Try If ActiveCell.Column < 4 Then 'your current code End If OR place the below on top of your current procedure If ActiveCell.Column = 4 Exit Sub -- Jacob (MVP - Excel) "Basta1980" wrote: G'morning, I have a to-do-list in Excel consisting of 5 columns (A:E). Every new task is on a new row. If needed I can create tasks in Outlook with the help of commandbutton (which has code assigned to it that extracts the info I need to the body of the task). What I would like to do now is to create an extra statement (within the current statement) that states that if I'm not in a cell in column D the code behind the commandbutton does not work (to prevent faults or tasks that are unclear). Any help would be greatly appreciated. Regards, Basta 1980 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
| Adjustable Cells (Changing Cells) Limit - Solver | Excel Discussion (Misc queries) | |||
| Cells are selected but aren't displayed as selected | Excel Discussion (Misc queries) | |||
| Cells are selected but aren't displayed as selected | Excel Worksheet Functions | |||
| Macro to take selected cells times a selected cell | Excel Programming | |||
Hybrid Mode
