reference to a range of cells as input for a macro

Hello

I would like to ask you if you know some way to accomplish this.

I want to create a macro which asks some information like functions do. For example, I would like the macro to ask for some data to be filled by the user. For that purpose I thought about using the inputBox vba function. I wanna fill the field in the inputBox with a reference to a range from an excel sheet. So, I click on a cell and then I try to hold ctrl + down cursor to get all the range starting from that cell on until the last consecutive filled cell on the sheet. Nonetheless, the problem I have is that when I do ctrl+down cursor, I just do not get the reference I want, because it seems that the ctrl+down cursor combination does not work in the inputbox for filling a reference to a range of cells. Does anyone know some workaround to achieve this?

Thanks a lot.

Originally Posted by DonkeyOte

Without posting what you've used it's hard to comment in truth... are you using Application.InputBox, ie along the lines of:

Please Login or Register  to view this content.

I found that the keyboard short-cuts worked ok for me...

Thanks, I already solved it though, by setting the button property to TakeFocusOnClick to False in the button which was launching the macro.