Default data in an input box

[jonco]

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

 

[merjet]

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

Hth,
Merjet