Unable to select range by keyboard

[Ratan Bhushan]

Hi Team

I have prepared a UDF in which it asks user to select some range via Application.Inputbox method.

When it asks, it only lets user to select range by mouse and it does not let use keyboard.

Please suggest as the data is huge always whenever this is to be used.

Thanks
RatanB

 

[PCosta87]

Hi,

I've found this:
https://support.microsoft.com/en-us...-to-select-ranges-in-refedit-control-in-excel

I'm not sure if it is applicable to your situation since you are not using "RefEdit" controls but see if that helps anyway.

 

[Monty]

Ratan Bhushan

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