| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Making Cell Entry Mandatory
Hello:
I am using Excel 2003 and would like to make cell entry mandatory in the first 3 columns of my spreadsheet (exp. Column A, B & C). The following columns mean nothing unless information is put in the first 3 columns. Is there a way to set up these columns so that nothing else can be entered until there is something put in the first 3 columns. Thank You for your help! |
|
#2
|
|||
|
|||
|
This can be done in a VB event function.
"Sue T" wrote: Hello: I am using Excel 2003 and would like to make cell entry mandatory in the first 3 columns of my spreadsheet (exp. Column A, B & C). The following columns mean nothing unless information is put in the first 3 columns. Is there a way to set up these columns so that nothing else can be entered until there is something put in the first 3 columns. Thank You for your help! |
|
#3
|
|||
|
|||
|
Great, Do you know what that would be. Not to efficient in VB. Thank You
"StinkeyPete" wrote: This can be done in a VB event function. "Sue T" wrote: Hello: I am using Excel 2003 and would like to make cell entry mandatory in the first 3 columns of my spreadsheet (exp. Column A, B & C). The following columns mean nothing unless information is put in the first 3 columns. Is there a way to set up these columns so that nothing else can be entered until there is something put in the first 3 columns. Thank You for your help! |
|
#4
|
|||
|
|||
|
I would need more info about your columns in your spreadsheet to give you the
correct code. How many columns are dependant on the 3 required fields? "Sue T" wrote: Great, Do you know what that would be. Not to efficient in VB. Thank You "StinkeyPete" wrote: This can be done in a VB event function. "Sue T" wrote: Hello: I am using Excel 2003 and would like to make cell entry mandatory in the first 3 columns of my spreadsheet (exp. Column A, B & C). The following columns mean nothing unless information is put in the first 3 columns. Is there a way to set up these columns so that nothing else can be entered until there is something put in the first 3 columns. Thank You for your help! |
|
#5
|
|||
|
|||
|
Hi - 14 columns from D to Q Thank YOu
"StinkeyPete" wrote: I would need more info about your columns in your spreadsheet to give you the correct code. How many columns are dependant on the 3 required fields? "Sue T" wrote: Great, Do you know what that would be. Not to efficient in VB. Thank You "StinkeyPete" wrote: This can be done in a VB event function. "Sue T" wrote: Hello: I am using Excel 2003 and would like to make cell entry mandatory in the first 3 columns of my spreadsheet (exp. Column A, B & C). The following columns mean nothing unless information is put in the first 3 columns. Is there a way to set up these columns so that nothing else can be entered until there is something put in the first 3 columns. Thank You for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula for a fixed cell minus last entry on ongoing log | Excel Worksheet Functions | |||
| Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) | |||
| Manual or Formula entry in cell. | Excel Discussion (Misc queries) | |||
| stop cell entry being copied to other cell | Excel Worksheet Functions | |||
| Function making cell really "empty" | Excel Worksheet Functions | |||
Linear Mode
