Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
InputBox
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
InputBox
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
InputBox
-- -Thank you Bob. So, as I understand it, there is both a function and a method version of InputBox in Excel. How might I find out more about the method version? Specifically, what the Type parameter means. If someone could walk me through exactly how one finds out about the details of a method such as InputBox in Excel 2007 I would be most appreciative. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
InputBox
From VBA help.................
Type Optional Variant. Specifies the return data type. If this argument is omitted, the dialog box returns text. Can be one or a sum of the following values. Value Meaning 0 A formula 1 A number 2 Text (a string) 4 A logical value (True or False) 8 A cell reference, as a Range object 16 An error value, such as #N/A 64 An array of values Gord Dibben MS Excel MVP On Wed, 11 Jul 2007 13:54:03 -0700, GeorgeJ wrote: -Thank you Bob. So, as I understand it, there is both a function and a method version of InputBox in Excel. How might I find out more about the method version? Specifically, what the Type parameter means. If someone could walk me through exactly how one finds out about the details of a method such as InputBox in Excel 2007 I would be most appreciative. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
InputBox
--Thank you Gord. That was extremely helpful. I am very impressed and grateful for the prompt help available on this forum. I will repeat my more general questions 1) what exactly does Walkenback mean when he writes (pg. 324) " Do not confuse Excel's InputBox method with VBA's InputBox function. Although these two items have the same name they are not the same" ? Can someone show a short bit of VBA code which uses both the Excel Inputbox method and VBA InputBox Function ? 2) Is there any way, other than posting a question on this forum, that I could have discovered the information Gord presented on his post? This forum is great but I am trying to find out if there is any way to find information on the details of Excel methods such as InputBox without going to a forum. Perhaps I'm not using Excel's help system efficiently, but I drew a blank when I tried to use HELP to find InputBox. If someone could specify the exact trail I should have followed it would be very helpful to me. -regards |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
InputBox
I found the material I posted in VBA help under "InputBox".
The top two items returned were "InputBox Method" as it applies to Application and "InputBox Function(VBA) Gord On Wed, 11 Jul 2007 16:32:02 -0700, GeorgeJ wrote: --Thank you Gord. That was extremely helpful. I am very impressed and grateful for the prompt help available on this forum. I will repeat my more general questions 1) what exactly does Walkenback mean when he writes (pg. 324) " Do not confuse Excel's InputBox method with VBA's InputBox function. Although these two items have the same name they are not the same" ? Can someone show a short bit of VBA code which uses both the Excel Inputbox method and VBA InputBox Function ? 2) Is there any way, other than posting a question on this forum, that I could have discovered the information Gord presented on his post? This forum is great but I am trying to find out if there is any way to find information on the details of Excel methods such as InputBox without going to a forum. Perhaps I'm not using Excel's help system efficiently, but I drew a blank when I tried to use HELP to find InputBox. If someone could specify the exact trail I should have followed it would be very helpful to me. -regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another InputBox question... | Excel Discussion (Misc queries) | |||
inputbox | Excel Discussion (Misc queries) | |||
InputBox size | Excel Discussion (Misc queries) | |||
Inputbox with VBA | Excel Discussion (Misc queries) | |||
Inputbox with Listbox | Excel Discussion (Misc queries) |