ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Default data in an input box (https://www.excelbanter.com/excel-programming/383887-default-data-input-box.html)

jonco

Default data in an input box
 
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

Default data in an input box
 
Change your last argument to something like
Sheets("Sheet1").Range("A5") and you got it.

Hth,
Merjet




All times are GMT +1. The time now is 10:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com