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 |
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