Required information in a cell

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi

I'm not sure if this possible, but is there a way to format some cells
so that they have to have information put in them. I know it's
possible in Access, but when tabbing along a row I want to be able
have the cursor not move out of the cell until information has been
input

TIA
Steve
 
One way. Modify to suit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
If Target.Offset(, -1) = "" Then
Target.Offset(, -1).Select
MsgBox "Pleae fill in"
Else
Target.Offset(, 1).Select
End If
End If
End Sub
 
Hi

I'm not sure if this possible, but is there a way to format some cells
so that they have to have information put in them. I know it's
possible in Access, but when tabbing along a row I want to be able
have the cursor not move out of the cell until information has been
input

TIA
Steve
Click to expand...

Hi Steve,

From what I can tell Don's solution is the only way to enforce data to
be entered. There is Data Validation in excel, but it only enforces
data integrity of the cell and does not force data to be entered.

Joel
 
One way. Modify to suit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
If Target.Offset(, -1) = "" Then
Target.Offset(, -1).Select
MsgBox "Pleae fill in"
Else
Target.Offset(, 1).Select
End If
End If
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

news:[email protected]...
Click to expand...

Hi Don
Can you point me in the direction of maybe a tutorial on how to do
this, It's a bit over my head

TIA
Steve
 
A worksheet event needs to go in a worksheet module. Right click sheet
tab>view code>copy/paste my code>play with it to see what it is doing and
then add other if's. You didn't give a lot of detail in your original
request. What I said was if you made a change to a cell in col C and the
cell immediately to the left was blank, go back to the the blank cell and
fill in before proceeding. Else, proceed to the cell just to the right for
the next entry. Play with it.
 
Back
Top