I am looking for code to assign the following macro:
Ctrl+[n1]: Fill the active cell in column [n2] with digit [n3] -> Go to the cell in the next column in the same row and fill in that cell with digit [n4]
n1 would be a variable letter (a, or b, or c, etc.)
n2 would be a variable column letter (A, or B, or C, etc.)
n3 would be a variable digit (1, or 2, or 3, etc.)
n4 would be a variable digit (1, or 2, or 3, etc.)
Does anyone know what the VBA-code would be for, for instance:
Ctrl+[a]: Fill the active cell with digit 1 -> Go to the cell in the next column in the same row and fill in that cell with digit 1
and for, for instance:
Ctrl+: Fill the active cell with digit 1 -> Go to the cell in the next column in the same row and fill in that cell with digit 7
If C14 would be the active cell,
macro Ctrl+[a] would lead to the following content being filled in: C14 -> 1 and D14 -> 1
macro Ctrl+ would lead to the following content being filled in: C14 -> 1 and D14 -> 7
CA
Ctrl+[n1]: Fill the active cell in column [n2] with digit [n3] -> Go to the cell in the next column in the same row and fill in that cell with digit [n4]
n1 would be a variable letter (a, or b, or c, etc.)
n2 would be a variable column letter (A, or B, or C, etc.)
n3 would be a variable digit (1, or 2, or 3, etc.)
n4 would be a variable digit (1, or 2, or 3, etc.)
Does anyone know what the VBA-code would be for, for instance:
Ctrl+[a]: Fill the active cell with digit 1 -> Go to the cell in the next column in the same row and fill in that cell with digit 1
and for, for instance:
Ctrl+: Fill the active cell with digit 1 -> Go to the cell in the next column in the same row and fill in that cell with digit 7
If C14 would be the active cell,
macro Ctrl+[a] would lead to the following content being filled in: C14 -> 1 and D14 -> 1
macro Ctrl+ would lead to the following content being filled in: C14 -> 1 and D14 -> 7
CA