In a worksheet where you have to fill in information what formula to use if
you want to make sure (example cell A1 is filled in before A2) In other words
they if A1 is not filled in you cant move to A2.

To make sure A1 is filled before A2

1. Select A2

2. Enter the below formula in DataValidationCustom and uncheck Ignore blank
=$A$1<""

3. Enter an error message say "Cells A1 should be entered firts" in Data
ValidationError Alert....and click OK.

If this post helps click Yes
---------------
Jacob Skaria


"Link" wrote:

In a worksheet where you have to fill in information what formula to use if
you want to make sure (example cell A1 is filled in before A2) In other words
they if A1 is not filled in you cant move to A2.

Hi Jacob,
The formula worked for one worksheet, but the other one already have a data
validation formula and it did not worked. Any other suggestion?
"Jacob Skaria" wrote:

To make sure A1 is filled before A2

1. Select A2

2. Enter the below formula in DataValidationCustom and uncheck Ignore blank
=$A$1<""

3. Enter an error message say "Cells A1 should be entered firts" in Data
ValidationError Alert....and click OK.

If this post helps click Yes
---------------
Jacob Skaria


"Link" wrote:

In a worksheet where you have to fill in information what formula to use if
you want to make sure (example cell A1 is filled in before A2) In other words
they if A1 is not filled in you cant move to A2.

You need to apply this for each worksheet.
--
If this post helps click Yes
---------------
Jacob Skaria


"Link" wrote:


Hi Jacob,
The formula worked for one worksheet, but the other one already have a data
validation formula and it did not worked. Any other suggestion?
"Jacob Skaria" wrote:

To make sure A1 is filled before A2

1. Select A2

2. Enter the below formula in DataValidationCustom and uncheck Ignore blank
=$A$1<""

3. Enter an error message say "Cells A1 should be entered firts" in Data
ValidationError Alert....and click OK.

If this post helps click Yes
---------------
Jacob Skaria


"Link" wrote:

In a worksheet where you have to fill in information what formula to use if
you want to make sure (example cell A1 is filled in before A2) In other words
they if A1 is not filled in you cant move to A2.

You need to apply this for each worksheet.
--
If this post helps click Yes
---------------
Jacob Skaria


"Link" wrote:


Hi Jacob,
The formula worked for one worksheet, but the other one already have a data
validation formula and it did not worked. Any other suggestion?
"Jacob Skaria" wrote:

To make sure A1 is filled before A2

1. Select A2

2. Enter the below formula in DataValidationCustom and uncheck Ignore blank
=$A$1<""

3. Enter an error message say "Cells A1 should be entered firts" in Data
ValidationError Alert....and click OK.

If this post helps click Yes
---------------
Jacob Skaria


"Link" wrote:

In a worksheet where you have to fill in information what formula to use if
you want to make sure (example cell A1 is filled in before A2) In other words
they if A1 is not filled in you cant move to A2.

use the sheet's change method ....right click the sheet tab and select View
Code from the pop-up menu

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("a2").Address Then
If Range("a1") = "" Then
MsgBox "A1 is empty"
Application.EnableEvents = False
Target.Value = ""
Application.EnableEvents = True
End If
End If
End Sub


"Link" wrote in message
...
In a worksheet where you have to fill in information what formula to use
if
you want to make sure (example cell A1 is filled in before A2) In other
words
they if A1 is not filled in you cant move to A2.

I am confused. After I click on view code where do I type all this information?

"Patrick Molloy" wrote:

use the sheet's change method ....right click the sheet tab and select View
Code from the pop-up menu

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("a2").Address Then
If Range("a1") = "" Then
MsgBox "A1 is empty"
Application.EnableEvents = False
Target.Value = ""
Application.EnableEvents = True
End If
End If
End Sub


"Link" wrote in message
...
In a worksheet where you have to fill in information what formula to use
if
you want to make sure (example cell A1 is filled in before A2) In other
words
they if A1 is not filled in you cant move to A2.