Fast Single Digit Entering

You can get input from a userform or inputbox, in this case the inputbox would be easiest.

The only alternative wold be to use a cell & probably worksheet change event

Hi royUK
Changing a cell would work. However, the macro does not
allow me to change a cell while it is running or in wait state.
From what I understand a worksheet change event does the
opposite of what I need, starts a macro when a cell changes
vs. changing a cell while a macro is running.
Inputbox would work, but would require me to confirm OK for every
time the macro loops through 52 set of calculations. The macro takes
about 25 minutes to run. (I have a HP, Quad core, with 8 GB RAM)
Thank you for your time.
Regards
Al

You could use a modeless userform with a textbox, use the textbox change event to capture single-keystroke data entries and clear the input, plus an on-time event to enter data if the user is idle.

I don't have access to Excel for the next few days, sorry.

An example workbook might help

Here is something you can use

Make a Userform with 1 textbox

Please Login or Register  to view this content.