Public col_bloque As Integer, flag_bloque As Boolean, lig_bloque As Long
Sub gw_bloque()
If flag_bloque = True Then
Application.OnKey "{Enter}", "gwsuivant"
Application.OnKey "{Right}", "gwsuivant"
Application.OnKey "{Return}", "gwsuivant"
Application.OnKey "{Tab}", "gwsuivant"
Application.OnKey "{Down}", "gwsuivant"
Application.OnKey "{Up}", "gwprecedent"
Application.OnKey "{Left}", "gwprecedent"
Application.OnKey "+{Tab}", "gwprecedent"
Else
Application.OnKey "{Enter}"
Application.OnKey "{Return}"
Application.OnKey "{Right}"
Application.OnKey "{Left}"
Application.OnKey "{Tab}"
Application.OnKey "{Down}"
Application.OnKey "{Up}"
Application.OnKey "+{Tab}"
End If
End Sub
Sub gwsuivant()
lig_bloque = lig_bloque + 1
If Sheets("bloque").Cells(lig_bloque, col_bloque).Value = "" Then lig_bloque = 2
Range(Sheets("bloque").Cells(lig_bloque, col_bloque).Value).Select
End Sub
Sub gwprecedent()
lig_bloque = lig_bloque - 1
If lig_bloque = 1 Then lig_bloque = Sheets("bloque").Cells(65536, col_bloque).End(xlUp).Row
Range(Sheets("bloque").Cells(lig_bloque, col_bloque).Value).Select
End Sub