How can I make a user fill out a cell

E

eluehmann

I need to have a user fill out a certain cell. I want to make sure tha
this cell is filled out before the user leaves this tab (or sheet)
tried validation but can not figure it out. When a user enters th
sheet the cell is blank. They need to fill in a start date. If ther
is a start date filled in then I need them to put in an end date. I
there is no end date I do not want them to be able to leave the sheet.
Any suggestions? :confused
 
J

jeff

Hi,

This is not a total solution, but should take you part
way. step 1 hides Sheet2, so the user can't "go on";
step 2 checks if there's a value (not validated) in
"end date" (I assume to be in B2), then show Sheet2.

1. in VB editor, select "This_Workbook" module and
paste this:

Private Sub Workbook_Open()
Sheet2.Visible = xlSheetVeryHidden
End Sub


2. right-click on sheet1 tab, select view code, paste:

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("B2").Value > "" Then Sheet2.Visible =
xlSheetVisible
End Sub


jeff
 
Top