Default data in an input box

's Computer Specifications

I want to have Excel enter the value of a particular cell as the DEFAULT
entry of an input box. Is this possible?

ActiveCell = InputBox("Note?, Add a Note to Transaction", , (A5))

*In this examplethe value of cell A5 would be the Default data for the input
box.

I'm not sure what the syntax is if it's possible.

Thanks for the help.

Jon

's Computer Specifications

Change your last argument to something like
Sheets("Sheet1").Range("A5") and you got it.

Hth,
Merjet

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cell Color changes On Input even if new input matches default	JBark	Microsoft Excel Programming	1	25th Sep 2009 05:24 AM
Default Value when input data	Maracay	Microsoft Access Reports	3	8th Dec 2008 11:19 PM
How to change to default font from Asian input to Latin input?	=?Utf-8?B?b3htb24=?=	Microsoft Word Document Management	6	19th Apr 2006 12:50 AM
use input box data as default value	=?Utf-8?B?Q2h1Y2syMTY=?=	Microsoft Access	2	4th Jan 2006 10:09 PM
How do I add input data in the input ranges in drop down boxes.	oil_driller	Microsoft Excel Misc	1	9th Nov 2005 10:31 PM