Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 40
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Another InputBox question... Phil Excel Discussion (Misc queries) 4 April 12th 07 03:37 PM
inputbox brownti via OfficeKB.com Excel Discussion (Misc queries) 2 February 9th 07 02:37 PM
InputBox size jamphan Excel Discussion (Misc queries) 0 April 6th 06 09:01 PM
Inputbox with VBA Jeff Excel Discussion (Misc queries) 3 January 19th 06 05:18 PM
Inputbox with Listbox Jeff Excel Discussion (Misc queries) 3 December 22nd 04 05:54 PM


All times are GMT +1. The time now is 01:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"