<p>I am writing a quick application myself - first project, however I am trying to find the VBA code for writing the result of an input string to a named cell in Excel.</p>

<p>For example, a input box asks the question "Which job number would you like to add to the list?"... the user would then enter a reference number such as "FX1234356".  The macro then needs to write that information into a cell, which I can then use to finish the macro (basically a search in some data).</p>

You can use the Range object in VBA to set the value of a named cell, just like any other cell.
```
```
Range("C1").Value = Inputbox("Which job number would you like to add to the list?)
```
```
Where "C1" is the name of the cell you want to update.
My Excel VBA is a little bit old and crusty, so there may be a better way to do this in newer versions of Excel.