I have to enter data (numbers) in an Excel column (let's say column B).
Some rows may be skipped. Some numbers need to be repeated. How could I,
instead of retyping, reproduce the last entered numbered in another cell,
with a specific key (let's say the * of the numeric keypad)

It appears to me that it is necessary to intercept keycodes in VBA, but I
cannot find any information about generating such event to a worksheet.

tx, ko