String from inputBox will not store(by .Value) in a cell (g

[nicademas]

Is there something special to do in order to get this data from an input cell and store(by .value perhaps) in a cell?

 

[Derek]

Hi Nicademas
Do you want a cell to display the answer from an input box? If so you can use syntax like this:

Range("F8").Value = InputBox("How many chickens?")

Whatever they put in the input box ends up in cell F8. You can restrict the replies (see Help)

If you are doing this and nothing displays in the cell, check the underlying formatting of the cell or any conditional formatting that could be hiding it.

Hope this helps
Derek
This message was edited by Derek on 2002-02-21 16:57

 

[Juan Pablo González]

To restrict entries, you must use Application.InputBox, the InputBox alone doesn't have this capability.