Inputbox function or Inputbox method? Inputbox method is/was

Application.Inputbox(Prompt:="Select Range", Type:=8)

I don't have 2007, so can't help you any more than this.



"Bob-wants-to-know" wrote:

I don't see how the Input Box function works in 2007. Used to be that you
could set the type for =8, and when you used the function, you could click on
a cell, and the contents or the cell reference was returned. How would I
replicate this type of action in my 2007 Macro?
thanks