Excel – Keyboard shortcuts for selecting range using Inputbox in Excel

microsoft excelmicrosoft-excel-2010

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 Application.Inputbox with 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?

Best Answer

I think this might be a similar issue as with the Ref Edit Control, see MS KB 213776 for details about this control which you can use for VBA UserForms. (I make extensive use of this control in my VBA solutions.)

Microsoft has provided a workaround for the problem with the Ref Edit Control here: MS KB 291110 and I can imagine this will also help you with the Application.InputBox-problem.

Edit: and after posting my answer I noticed that this question has been asked AGES ago... :-(

Related Question