Hi,

Not quite sure what you mean. Are you trying to select from a pre-determined list of values and have your selection in A1. In that case just use the Data Validation List functionality.
If not why not just enter the Value directly in A1.

In either case then read your data into a script variable with 

MyVariable = Sheets("MySheet").Range("A1")
HTH