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!

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!

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!

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!

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!