Excel Guides

Controlling Entry Order on Unprotected Cells in Excel

There are a few ways to control the entry order on unprotected cells in Excel. One way is to use the data validation feature. This can be found under the Data tab, in the Data Tools group. Click on Data Validation and then select the settings you want to use. You can specify that only certain values are allowed, or that a certain value must be entered first. You can also use data validation to make sure that a value is entered in a specific format, such as a date or time.

Another way to control entry order is to use conditional formatting. This can be found under the Home tab, in the Styles group. Click on Conditional Formatting and then select the settings you want to use. For example, you could highlight cells that are empty or that contain invalid data. You can also use conditional formatting to make sure that a value is entered in a specific format, such as a date or time.

You can also use VBA code to control entry order. For example, you could use the following code to make sure that a value is entered in a specific format:

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Range("A1:A10")) Is Nothing Then

        If Not IsDate(Target) Then

            MsgBox "Please enter a date in the format dd/mm/yyyy"

            Target.ClearContents

        End If

    End If

End Sub

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.