force order

[deanl33069]

How can i force a user to fill in cells in an order?
c3 first f3 second h3 third ect...

 

[DanteAmor]

Put the following code in the events of your sheet.
Change or add cells in the red part.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Set r = Range("[COLOR=#ff0000]C3, F3, H3[/COLOR]")
    For Each c In r
        If c.Value = "" Then
            MsgBox "Fill cells " & c.Address(0, 0)
            Application.EnableEvents = False
            c.Select
            Application.EnableEvents = True
            Exit For
        End If
    Next
End Sub

SHEET EVENT
Right click the tab of the sheet you want this to work, select view code and paste the code into the window that opens up.