Function
x=Inputbox("Age?")

Method:
x=Application.Inputbox("Age?",Type:=1)

There is no Type argument in the Function vesion.


"GeorgeJ" wrote in message
...
I am using John Walkenbach's excellent EXCEL 2006 - POWER PROGRAMMING WITH
VBA

On page there is the following code

Set UserRange = Application.InputBox( _
Promopt:=Prompt, _
Title:=Title, _
Default:=ActiveCell.Address, _
Type:=8)


I have verified that this code complies and runs as indicated in the book.

On the previous page the author advises the reader not to confuse Excel's
InputBox function with VBA's InputBox function.

On page 326 the author writes "specifying a Type argument of 8 for the
InputBox method is the key to this procedure"

I have been unsuccessful in trying to find out anything about Excel's
InputBox procedure. I have tried jumping around in Excel's help file and
haven't been able to see any mention of this procedure. I would sure
appreciate it if someone could show me, with some specificity, how to find
out about this procedure.
--
-regards