Data Validation Blank Cells
 

Hello!

I have created a worksheet with all the cells locked except the ones I want
the information in and the sheets protected.

The user can then tab from one cell to the other entering information, I
would like to make it so they have to enter information in the cells or the
warning is set off stating that they need to enter information. How can I do
this?

Thank you.
Lou

Data Validation Blank Cells
 

Assumes you have "select locked cells" disabled under ToolsProtectionProtect
Sheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox "you must enter data in this cell"
End Sub

This is sheet event code. Right-click on the sheet tab and "View Code"

Copy/paste into that sheet module.


Gord Dibben MS Excel MVP

On Wed, 10 Oct 2007 15:20:01 -0700, Louis Markowski
wrote:

Hello!

I have created a worksheet with all the cells locked except the ones I want
the information in and the sheets protected.

The user can then tab from one cell to the other entering information, I
would like to make it so they have to enter information in the cells or the
warning is set off stating that they need to enter information. How can I do
this?

Thank you.
Lou

Data Validation Blank Cells
 

Gord,
Thank you! When I use the code the message box pops up before and after
every time i hit enter. I would like it to activate when the user exits the
cell and only if they left it blank, thoughts?

Thank you.
Lou

"Gord Dibben" wrote:

Assumes you have "select locked cells" disabled under ToolsProtectionProtect
Sheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox "you must enter data in this cell"
End Sub

This is sheet event code. Right-click on the sheet tab and "View Code"

Copy/paste into that sheet module.


Gord Dibben MS Excel MVP

On Wed, 10 Oct 2007 15:20:01 -0700, Louis Markowski
wrote:

Hello!

I have created a worksheet with all the cells locked except the ones I want
the information in and the sheets protected.

The user can then tab from one cell to the other entering information, I
would like to make it so they have to enter information in the cells or the
warning is set off stating that they need to enter information. How can I do
this?

Thank you.
Lou