Copy Value in Excel
 

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

Copy Value in Excel
 

Look in vba help at the ONKEY function

--
Regards,
Tom Ogilvy

Ko Vijn wrote in message
...
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