| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Default data in an input box
Change your last argument to something like
Sheets("Sheet1").Range("A5") and you got it. Hth, Merjet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Input box default = last input | Excel Programming | |||
| default name and value in input cell | Excel Worksheet Functions | |||
| Input Box default value as a date | Excel Programming | |||
| Retaining the default in an input box - again | Excel Programming | |||
| Retaining a default in an input box | Excel Programming | |||
Linear Mode
