I am using Excel 2010 and I have a problem with using keyboard shortcuts for choosing ranges in an Inputbox.
I am using a standard
type:=8. The code prompts the user to open a file (an already existing workbook) and then prompts him with this Inputbox to select a range.
I am able to select the range with the mouse. However, the keyboard shortcuts (like CTRL+SHIFT+DOWN ARROW or CTRL+SHIFT+LEFT ARROW) for selecting a range don't work completely:
They work when I select a range in the same workbook where the code is, but they don't work on a newly opened workbook.
Is there a way to enable keyboard selection for ranges?